Forum Discussion
Multiple filters overlapping
I found a fantastic article that solved this for me.
Applying filters with OR and XOR conditions in Power BI — Apex Insights: Power BI tips & tricks
It is important to note that the measure goes here:
AND you need to create the tables using VALUES DAX here:
Hi,
To your Table visual, drag the Customer, Territory and the measure.
The fomula is on the bar above. HOWEVER, this formula seems to work only as a card. What I want is a table that displays the selected values in the filter.
The filters by default use a logical AND argument. It will say "Google AND A112 AND A115." I am looking for a way to get the filter to use an OR argument.
You can see the red boxed values on the left. I would like a table to show ONLY the red boxed valued (which are based on the filters on the right).