Return all rows for which column contains specific keyword

[Anonymous]

I have a table with Title column. I need to return all rows for which Title Contains "Keyword".

Do I need to return a new CALCULATETABLE for this? 

Please help me with DAX ? 

Thanks 

[JarroVGIT]

You can use this DAX filter expression:

FILTER(Table, CONTAINSSTRING(Table[Column], "Keyword" = TRUE)

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂

[Anonymous · Accepted solution]

@JarroVGIT 

This worked though 🙂 

FILTER(Workitems, CONTAINSSTRING(Workitems[Title], "[Reg"))

[JarroVGIT]

Good to hear my solution worked, although I didn't understood you wanted a calculated table as a result 🙂

[Anonymous]

Hi @JarroVGIT 

I am trying a new table with your syntax : 

[mwegener]

Hi @Anonymous ,

can't you use an advance filter?

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

[Anonymous]

Hi @mwegener I can use the visual filter but then I need this values to do more calculation on it like count, filter by type etc. 

I would have to put the same filter on all those variations for different goals.

I prefer something like a CalculatedTable that contains  those filtered values and then I can just refer the table for visual.