Forum Discussion

Jos13's avatar
Jos13
Icon for Helper III rankHelper III
6 years ago
Solved

RANKX with ALL()

Hi Team, I have 2 measures to rank categories and products based on sales.   Category_Rank_All_Column = RANKX(ALL(Categories[CategoryName]),[Total Sales],,DESC) ProductRanking = RANKX(ALL(Prod...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Jos13 ,

     

     

    Have a look at this video to understand the difference between ALL() and ALLSELCTED() when used with RANKX.

     

     

    https://www.youtube.com/watch?v=z2qzJVeYhTY

     


    Regards,

    Harsh Nathani


    Appreciate with a Kudos!! (Click the Thumbs Up Button)

    Did I answer your question? Mark my post as a solution!

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Does this work?

=Category_Rank_All_Column = RANKX(ALLSELECTED(Categories[CategoryName]),[Total Sales],,DESC)