Forum Discussion
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?
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
3 Replies
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 ZhangIt worked. Thanks
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.
