Forum Discussion

SergiodePao's avatar
SergiodePao
New Member
3 years ago

DAX formula Using a Measure to search within a text string.

Good day All,   Im willing to Search text within a text string. the challenge im facing is that insted of text im willing to use a variable or Measure based on user input, here is my first attempt ...
SergiodePao's avatar
SergiodePao
New Member
3 years ago

Thank You KeyurPatel14 for your willines to help, 

Unfourtunatelly I try did not work ,  when we use a Measure in the condition, like the one you are proposing

Column 1 = CONTAINSSTRING(groupofcities[Cities],[Test]) for some reasson the results is that all rows are TRUE even if they do not contain "KC".

 

I also tried to add an slicer where each city is listed individually , it does work but the problem is that the row that contains "KC" in a group as the row identified as DET, CHI, KC, HOU, still shows FALSE.  in other hand the row that only contain KC that one is TRUE. 

Maybe Im overcomplicating my dashboard but it is required. 

 

  • KeyurPatel14's avatar
    KeyurPatel14
    Responsive Resident
    3 years ago

    Then You can use CONTAINSSTRING() DAX Function to solve your problem.
    If you have any queries then please let me know.