Forum Discussion

MelbourneBadger's avatar
MelbourneBadger
Helper I
5 years ago
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.   
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    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's avatar
    MelbourneBadger
    Helper I
    5 years ago

    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's avatar
      Greg_Deckler
      Community Champion
      5 years ago

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

       

      • MelbourneBadger's avatar
        MelbourneBadger
        Helper I
        5 years ago

        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