Forum Discussion

hellgoingon's avatar
hellgoingon
Helper II
9 years ago
Solved

Visual level filters - How to filter 3 fields using And OR operator

Hi all,   In my reports (using table to display data), i have 3 fields (A, B and C). I want to filter data like: (A = 1 or B = 2) and C = 3   How can i do that?
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi hellgoingon,

    We are not able to directly use Visual level filters to achieve your requirement. In your scenario, you can create a calculated table using the following formula and then create a table visual using the new created table.

    Table = CALCULATETABLE(Table1, FILTER(Table1,(Table1[A]=1||Table1[B]=2)&&(Table1[C]=3)))



    For more details, you can review this attached PBIX file.



    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi hellgoingon,

We are not able to directly use Visual level filters to achieve your requirement. In your scenario, you can create a calculated table using the following formula and then create a table visual using the new created table.

Table = CALCULATETABLE(Table1, FILTER(Table1,(Table1[A]=1||Table1[B]=2)&&(Table1[C]=3)))



For more details, you can review this attached PBIX file.



Thanks,
Lydia Zhang

hellgoingon's avatar
hellgoingon
Helper II
9 years ago

It worked. Thanks