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.

     

v-xulin-mstf's avatar
v-xulin-mstf
Icon for Community Support rankCommunity Support
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.