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 thi...
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.