Filtering on Text

[MelbourneBadger]

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. 

[Greg_Deckler]

@MelbourneBadger - Use the Text filters fly-out and use Contains.

[MelbourneBadger]

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. 

[Greg_Deckler]

@MelbourneBadger - Sorry, did the pic not post, I'll try again, this is not DAX:

[MelbourneBadger]

Thank you @Greg_Deckler 

I am actually trying to create new table with DAX expression based on data in another larger table using Filter function based on multiple boolean expressions

[Greg_Deckler · Accepted solution]

@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)

[MelbourneBadger]

Superb @Greg_Deckler ! Thank you very much. That's exactly what I needed.