Forum Discussion

atitarev's avatar
atitarev
Helper 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

     

     

     

atitarev's avatar
atitarev
Helper I
7 years ago

Update: I have changed the ranking measure to:

 

Sorting Rank = RANKX (
    ALLSELECTED( DATA[Consolidation] ),
    CALCULATE([Sort Measure]),,ASC,Skip
)

with a slight improvement but the rank gets reset to 1 when the values are 0. You can see that it's still not working. The measures involve use some time intelligence. Please let me know if you want me to post them.

 

  • themistoklis's avatar
    themistoklis
    Community Champion
    7 years ago

     

     

    atitarev

     

    How about this formula

     

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

     

     

     

    • atitarev's avatar
      atitarev
      Helper 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
        Community 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?