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

[hellgoingon]

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?

[mattchaplin]

How would this work if the values in the comparison were dynamic (i.e. user provided) rather than static?

A better example for this case may be a fact table of events with columns: Event_Name, Start_Date, End_Date. You have this fact connected to a Date dimension table on either Start_Date or End_Date. In your report, you have a slicer based on the Date.Month where a user can select one or more months, and in the report we want to see all events where the Start_Date OR the End_Date in in the selected months.

[v-yuezhe-msft · Accepted solution]

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]

It worked. Thanks