Home Forums Power Pivot How to Rank a list based on a second value to handle ties?

Tagged:

This topic contains 2 replies, has 2 voices, and was last updated by  fenixen 3 years ago.

Viewing 3 posts - 1 through 3 (of 3 total)
• Author
Posts
• #4997

fenixen
Participant
• Started: 7
• Replies: 12
• Total: 19

Current formula is as follows:

Overall Rank= RANKX(all(‘EM2016 Participants’);[Points])

This ranks all the participants by Sum([Points]), works like a charm..

BUT.. we want the RANK to be affected by a second column/value to determine the leader amongst the people with same score.

As we can see 7 people have an overall rank of 1. But when rank is identical “U poeng” should determine who the leader is. Currently its only sorted alphabetical.

Is it possible to do some sort of nested RANKX that gives rank based on two measures?

Nikil with 3 U points should be the last of Rank=1.

Ideally only one person should be rank 1 here and that is Bjørn since he is the only one with U poeng= 6.

###### Attachments:
You must be logged in to view attached files.
#5007

tomallan
Keymaster
• Started: 7
• Replies: 2556
• Total: 2563

Remi,

Try creating a calculated column with the following formula:

`Points with Tie Breaker= [Poeng] + ( [U poeng] / 1000 )`

then rank on that calculated column.

Am sure you have done something like this before.

Tom

#5010

fenixen
Participant
• Started: 7
• Replies: 12
• Total: 19

Actually haven’t done this, probably “hacked” stuff in regular Excel instead..