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

 

How about this formula

 

Rank = 
    RANKX(
        'DATA',
        'DATA'[Sort Measure],,
        ASC
        )

 

 

 

atitarev's avatar
atitarev
Icon for Helper I rankHelper I
7 years ago
Thank you, themistoklis but I only get non-sensical numbers. I need to get the context right.
  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    7 years ago

    atitarev

     

    Any chance to share the workspace with us and also an image on how the final dataset will look like?

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

      themistoklis, sorry, the data is sensitive and my account doesn't allow me to attach files yet, anyway.