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:
Hello there. I am sorry, I was unable to respond to this in a timely manner and am just now able to check back in. I am not sure who marked the answer as correct, but I was unable to get the formula above to work.
Here is a screenshot of what I am trying to do:
The first Matrix shows all the data in my database. The second matrix filters that data by account name (Google), and the last matrix shows it filtered by the territory ID (A112 and A115).
I want to create a view where I can see the sales for Google AND Territories A112 and A115. Right now, I only know how to do either/or.
Ideally, I would want to see this:
| Customer | Territory | Amount |
| Apple | A115 | $4,297.01 |
| Apple | A112 | $9,921.39 |
| A112 | $7,650.20 | |
| A112 | $8,944.28 | |
| A112 | $7,650.20 | |
| A112 | $9,421.05 | |
| A114 | $1,543.36 | |
| A112 | $8,944.28 | |
| A114 | $2,906.24 | |
| A117 | $3,507.63 | |
| A113 | $1,632.03 | |
| A113 | $859.21 | |
| A118 | $3,106.57 | |
| A112 | $9,421.05 | |
| Tesla | A112 | $5,807.01 |
Here, I can see every Google order AND every order under those two territories. I tried your formula a few different ways, but I am not understanding the logic of it so maybe I am not relating it to my table correctly. The above example is what I am looking for and the fields are the same as mine.
Hopefully this clarifies it better.
Thanks!
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).