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])
    )

     

     

Anonymous's avatar
Anonymous
Not applicable
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])
    )

 

 

Koushikrish's avatar
Koushikrish
Helper I
4 years ago

Anonymous : that worked great as well. Got the result as I desired for exactly! Thanks a lot for your help on this!! ðŸ˜Š