cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
abehrmann Regular Visitor
Regular Visitor

Need help ranking results for a Microsoft forum quiz

I am doing an improv test at a company meeting and the CEO wants to display the top score and the owner of the top score, 

 

i would like to rank first by score and if a tie then by shortest time to take the quiz 

 

Table Name

Table1

Column names  

total points 

name 

Time to take 

3 REPLIES 3
Super User
Super User

Re: Need help ranking results for a Microsoft forum quiz

Hi @abehrmann

 

The following will yield a table with the top participant(s) (plural if there were more than one with same top score and time). I've named the table Results instead of Table1  

 

TOPN ( 1; Results; Results[Points]; DESC; Results[Time]; ASC )

 

If you want a measure that displays the name see below. Note that this measure will display the warning if there were more than one participant with same top score and time: 

Measure =
CALCULATE (
    SELECTEDVALUE ( Results[Name]; "More than one candidate" );
    TOPN ( 1; Results; Results[Points]; DESC; Results[Time]; ASC )
)
abehrmann Regular Visitor
Regular Visitor

Re: Need help ranking results for a Microsoft forum quiz

Can you explain to do do the top suggestion?

Highlighted
Super User
Super User

Re: Need help ranking results for a Microsoft forum quiz

@abehrmann

 

Sure thing. What exactly do you  want me to explain?