Forum Discussion

atitarev's avatar
atitarev
Icon for Helper I rankHelper I
7 years ago
Solved

Ranking issue

Hi Power BI experts,   I am having an issue in getting the RANKX() working correctly for me.   The ranking column is last, which is not working. It's based on the previous column "Sort". T...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    atitarev

     

    Try the following formula:

     

    Sorting Rank = IF (
    HASONEVALUE ( DATA[Consolidation] ), 
    RANKX ( ALL ( DATA[Consolidation], DATA[Level Leader] ), [Sort Measure], , ASC, Dense)
)

    It shows this ranking

     

     

     

themistoklis's avatar
themistoklis
Icon for Community Champion rankCommunity Champion
7 years ago

atitarev

 

Try the following formula:

 

Sorting Rank = IF (
    HASONEVALUE ( DATA[Consolidation] ), 
    RANKX ( ALL ( DATA[Consolidation], DATA[Level Leader] ), [Sort Measure], , ASC, Dense)
)

It shows this ranking

 

 

 

atitarev's avatar
atitarev
Icon for Helper I rankHelper I
7 years ago

Thank you, themistoklis! That's exactly what I need.