Expression if Row contains value

[JWipke]

I'm looking to write an expression to only display rows that contain "Florida". In some cases it's at the beginning, in others in the middle, and others at the end. I can select existing filters to do this, but want the view to only display those rows by default.

[rubenmarin]

Hi, there are different ways to do that, in example if you have a location field, you can add some dimensions and use a measure for this field to show:

Only({<Location={"*Florida*"}>} Location)

or MaxString({<Location={"*Florida*"}>} Location)