Forum Discussion

DPJay's avatar
DPJay
Regular Visitor
7 years ago
Solved

Ranking

Hello,   I am trying to rank locations using RankX function based on quantity for each location. I'm not sure why I'm getting the same rank for multiple locations although the quantity is dif...
Need Help
Show and Tell
  • Sean's avatar
    Sean
    7 years ago

    Add the column you are Ranking I couldn't see the name in your picture above.

     

    Rank Measure =
IF (
    HASONEVALUE ( FINAL_TBL[Column you are Ranking] ),
    RANKX ( ALL ( FINAL_TBL[Column you are Ranking] ), [TOT_QTY] )
)
Sean's avatar
Sean
Community Champion
7 years ago

Add the column you are Ranking I couldn't see the name in your picture above.

 

Rank Measure =
IF (
    HASONEVALUE ( FINAL_TBL[Column you are Ranking] ),
    RANKX ( ALL ( FINAL_TBL[Column you are Ranking] ), [TOT_QTY] )
)
DPJay's avatar
DPJay
Regular Visitor
7 years ago

Hi Sean,

 

Thanks a lot..it worked :smileyhappy:

  • Sean's avatar
    Sean
    Community Champion
    7 years ago

    Great! :smileyhappy:
    I added IF ( HASONEVALUE (...) to get rid of the 1 in the Total Row at the bottom of the Visual