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,

v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
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,