cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
DPJay Frequent Visitor
Frequent Visitor

Ranking

location ranking.jpg

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 different.

Can anyone help me on this?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Ranking

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] )
)
5 REPLIES 5
Super User
Super User

Re: Ranking

Can you post the formulas for the RANK Measure and the TOT_QTY?

DPJay Frequent Visitor
Frequent Visitor

Re: Ranking

rank.jpgtot_qty.jpg

Super User
Super User

Re: Ranking

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 Frequent Visitor
Frequent Visitor

Re: Ranking

Hi Sean,

 

Thanks a lot..it worked Smiley Happy

Super User
Super User

Re: Ranking

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