Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Return all rows for which column contains specific keyword

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   
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago
    This worked though 🙂 
    FILTER(Workitems, CONTAINSSTRING(Workitems[Title], "[Reg"))
     
     
JarroVGIT's avatar
JarroVGIT
Icon for Resident Rockstar rankResident Rockstar
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago
This worked though 🙂 
FILTER(Workitems, CONTAINSSTRING(Workitems[Title], "[Reg"))
 
 
  • JarroVGIT's avatar
    JarroVGIT
    Icon for Resident Rockstar rankResident Rockstar
    6 years ago
    Good to hear my solution worked, although I didn't understood you wanted a calculated table as a result 🙂