Forum Discussion
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...
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] ) )
Can you post the formulas for the RANK Measure and the TOT_QTY?
