DAX Using Measure to Search

Sergio de Pao 0 Reputation points
2023-03-17T06:05:27.54+00:00

Using and learning Power BI I'm willing to Find text within a string using a Measure or variable.

Here is my attempt that works fine if I use text on the DAX Formula.

Column 1 = CONTAINSSTRING(Groupofcities[Cities],"KC")

Cities Column 1
DAL, HOU, DET, KC, CHI TRUE
DAL, HOU, CHI FALSE

This is what I'm willing to do but does not work

Column 1 = CONTAINSSTRING(Groupofcities[Cities], [Measure City])

Extra point if you help me on using multiple values, if KC and CHI are selected how can still say true to the first row and false to the second?

Thanks so much.

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,479 questions
0 comments No comments
{count} votes