Forum Discussion
Helper IIIRANKX with ALL()
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!
Super UserJos13 ,
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/367415
Try like
Category_Rank_All_Column = RANKX(ALLselected(Categories[CategoryName]),[Total Sales],,DESC)
Jos13Hi,
I had tried ALLSELECTED(). I just wanted to know why ALL() function gives different results.
Thanks,
Jos
- 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/
- AntrikshSharma
Community Champion
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. 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!
