Forum Discussion

PieroPinzone's avatar
PieroPinzone
Regular Visitor
3 years ago

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

    • PieroPinzone's avatar
      PieroPinzone
      Regular Visitor
      Massimo di Sales per Region =
      MAXX(
          KEEPFILTERS(VALUES('Merge2'[Region])),
          CALCULATE(SUM('Merge2'[Sales]))
  • lukiz84's avatar
    lukiz84
    Memorable Member

    what if you remove KEEPFILTERS? That's a calculate-modifier

    • PieroPinzone's avatar
      PieroPinzone
      Regular 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