Forum Discussion

smore's avatar
smore
Icon for Advocate I rankAdvocate I
5 years ago
Solved

DAX RANKX: Rank Column that ranks based on slicer selection?

[ Spoiler ] I have a slicer based on Table[Color] and a ranking measure that ranks items based on Table[Size]. When all colors are selected in the slicer it ranks every item. When a specific color i...
Need Help
  • v-xulin-mstf's avatar
    v-xulin-mstf
    5 years ago

    Hi smore,

     

    Do you want to show the overall ranking after applying the slicer?

    Here is the output:

    Try measure as:

    Rank Measure = 
RANKX(
    ALL('Table'),
    CALCULATE(SUM('Table'[Size]))
    ,, DESC
)

     

    Best Regards,

    Link

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

smore ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

smore's avatar
smore
Icon for Advocate I rankAdvocate I
5 years ago

I am not sure how to upload a pbix on the forum so here is a google drive link to a sample.pbix:

https://drive.google.com/file/d/1EeEjuF9_iQCPQIEeS7bZVKmOIii8GqEE/view?usp=sharing

After preparing the sample pbix I realized that the Rank Column is not ranking properly. I am not sure what is wrong with the DAX code for the Rank Column. I just want it to work the same as the Rank Measure. Thanks for your reply.