Forum Discussion

Koushikrish's avatar
Koushikrish
Helper I
4 years ago
Solved

DAX TOP N Measure on a Matrix Issue

Hello,   I have a requirement to display TOP 10 States on a Volume measure across a matrix visual. I have used the TOP N DAX Measure to achieve this :  CALCULATE([Volume], TOPN(10, ALL(dimGeograp...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    Koushikrish glad it worked!

    To also remove the filter from Brand, this below might work (I've not tested this)

     

        CALCULATE(
        [Volume],
        TOPN(10,
            ALL(dimGeography[State_Code], dimGeography[RegionName]),
            CALCULATE([Volume], ALL('dimBrand'[BrandName]))
            DESC
        ),
        VALUES(dimGeography[State_Code])
    )

     

     

amitchandak's avatar
amitchandak
Super User
4 years ago

Koushikrish , try if this can help

measure =
var _tab = TOPN(10, ALL(dimGeography[State_Code]), [Volume], DESC)
return
CALCULATE([Volume], FILTER(VALUES(dimGeography[State_Code]),dimGeography[State_Code] in _tab))

  • Koushikrish's avatar
    Koushikrish
    Helper I
    4 years ago

    Hi amitchandak , thanks for the response. This doesn't seem to fix the issue though. It doesn't appear to show just top 10 but all states and mapped to their corresponding region :