Forum Discussion
PieroPinzone
3 years agoRegular Visitor
How to exclude filtered items from a top N visualization
Hi guys, as showed in the screen, when i try to filter the top N barcharts by selecting a market in the ring chart, i don't get the desired result. Instead of showing results just from the selected market, i obtain the highlighting of the results if they belong the selected area.
4 Replies
- lukiz84Memorable Member
Please post your measure that includes TOPN.
- PieroPinzoneRegular VisitorMassimo di Sales per Region =MAXX(KEEPFILTERS(VALUES('Merge2'[Region])),CALCULATE(SUM('Merge2'[Sales]))
- lukiz84Memorable Member
what if you remove KEEPFILTERS? That's a calculate-modifier
- PieroPinzoneRegular Visitor
The problem is not how the measure is calculated, but how i can visually filter those elements (in the barchart) who are deselected by the donut