Forum Discussion
Solved
Multiple filters overlapping
I can't seem to figure this one out. I am trying to create a bookmark view where I see the data based on two criteria. However, these criteria overlap. To simplify, suppose I want a view that sh...
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:
jwin2424 , Create two independent table for Country and customer and use those as per need in filter
example
calculate(Sum(Fact[Value]), filter(Fact, Fact[Customer] in values(Customer[Customer]) ))
and
calculate(Sum(Fact[Value]), filter(Fact, Fact[Country] in values(Country[Country]) ))
Another way is to use removefilters or all if they are from the same/related tables
https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak