Forum Discussion
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 ...
KeyurPatel14
Responsive Resident
Responsive ResidentHi SergiodePao ,
You can plot a slicer and in that slicer you can add Cities column so the users can select cities from the slicer.
You can also make a measure using SELECTEDVALUE DAX Formula like this:
Test = SELECTEDVALUE(groupofcities[Cities])
this measure will select the values user select using the slicer.
Now you can pass this measure in your measure Column 1.
It would look like this:
Column 1 = CONTAINSSTRING(groupofcities[Cities],[Test])
I hope this will help to solve your problem and if you have any queries then please let me know.
If this helps you then please give it a kudos and mark it as a solution.
Thank you.