Forum Discussion

spaturu3234's avatar
spaturu3234
Frequent Visitor
9 years ago
Solved

How Do I Filter Multiple Values

I Need to filter on 100 values in dataset, How can I do that in DAX   Data: ID Column1  Column 2 etc... 1     A1 2     B1 3     C1 4     D1   so on ..   How Can I filter records which are ...
Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    spaturu3234

     

    In DAX, to filter table with "IN" condition, you can only make Column1 match each value and apply OR logic between them. 

     

    FILTER(Table,Table[Column1] = A1 || Table[Column1] = B1 || Table[Column1] = C1 || Table[Column1] = D1)

    Please also refer to this blog: From SQL to DAX: IN and EXISTS

     

     

    Regards,

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

First, are the categories really A1, B1, etc. or are you just using that as an example? Second, what are the other categories (like actual names?

 

A brute force way would be to create a column using nested IF statements (yuck!) or a SWITCH statement (cleaner) that simply returned 1 for included categories and 0 for categories you do not want included. You could then simply filter on that column for all values equal to 1.