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

AntrikshSharma's avatar
AntrikshSharma
Icon for Community Champion rankCommunity Champion
6 years ago
ALL removes filter from all the columns, or a table, on the other hand ALLSELECTED only takes in account any filter that is active outside of the given visual. in easier words whatever is at the grand total is what ALLSELECTED returns.