Forum Discussion
Solved
Filtering on Text
Hi All,
How can I filter all the rows that contain text LOC in the Risk Categories column as shown in a table below? I have tried using ? or * as wildcards text but they did not work.
MelbourneBadger Ohhhhhh... I did not get that from your original post, I was misled by the picture and just thought you were trying to filter the data view. OK, in that case you need to use FIND, SEARCH or CONTAINSTRING. So, something like:
New Table = FILTER('Old Table',FIND("LOC ",[Column],,0) <>0)
6 Replies
Thank you for your response Greg_Deckler
What did you mean by "uset the Text filters fly-out"? Sorry I'm new to DAX. Thank you before-hand.
