RANKX with ALL()

[Jos13]

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(Products[ProductName]),[Total Sales],,DESC)

When I select categories from slicer, products(Table2) ranked correctly but categories(Table 1) not.

Can someone please tell me the reason for this ?

Thanks in advance

[amitchandak]

@Jos13 ,

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

Try like

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

[Jos13]

Hi,

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

Thanks,

Jos

[harshnathani · Accepted solution]

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!

[AntrikshSharma]

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.

[amitchandak]

@Jos13 , Not sure from whom this question.

But All means remove the filter of that particular column, take all values, All selected to take selected values

Refer these fore more details

https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/

https://www.sqlbi.com/articles/managing-all-functions-in-dax-all-allselected-allnoblankrow-allexcept...

[Ashish_Mathur]

Hi,

Does this work?

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