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!

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

Hi,

I had tried ALLSELECTED(). I just wanted to know why ALL() function gives different results.

 

Thanks,

Jos

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