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.

DAX Using Measure to Search

Sergio de Pao 0

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.