Forum Discussion
String search and/or filter using another filtered table.
Hi all.
I have "P table" with column "Details".
Also I have "A table" with Column "Code" - this table is filtered (let's name this "BA filter" applied to different column "AO" - not sure ifg this infromation is needed)
I want to create a measure or calculated column to filter (or count rows in) "P table" where "Detail" column contains all possible values from "A table" column "Code".
And ofcause I need this to be based on "BA filter" selected at the moment.
Thank you in advance.
2 Replies
xyPMaHraPa , Not very clear, But you can measure like
Countrows(FIlter(PTable, PTable[Column] in Values(Atable[COlumn]) )
Or use treatas - https://docs.microsoft.com/en-us/dax/treatas-function
Hi, sorry for not responding so long time, now i'm back to thius excersise again.
Nice feature, but doesn't work for me. Column where I serach values from the initialy filtered column is not exact. it could contain initial values.
I'll try to draw:
Ptable
P_ID Details P0001 Detailed description of P0001 could contan A code such as MAR, CAR, or any other. O could contain no such info as a plain text. P0002 Detailed description of P0002 could contan A code such as MAR, CAR, FL01 or any other. O could contain no such info as a plain text. Atable
Code AO MAR MVM CAR MVM FL01 JP
X123 JP 478960 JPM So my target to monitor filter applied to Atable[AO]. Let's say it is filtered by 'JP'
And search all values from Code column ('FL01' and 'X123') in the text of PTable[Details].
So result should be P0002, since it contains 'FL01' in its body.
