Need help ranking results for a Microsoft forum quiz

[abehrmann]

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 

[AlB]

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]

Can you explain to do do the top suggestion?

[AlB]

@abehrmann

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