Reply
Regular Visitor
Posts: 22
Registered: ‎08-03-2018

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 

Highlighted
AlB Member
Member
Posts: 184
Registered: ‎11-12-2018

Re: Need help ranking results for a Microsoft forum quiz

[ Edited ]

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 )
)
Regular Visitor
Posts: 22
Registered: ‎08-03-2018

Re: Need help ranking results for a Microsoft forum quiz

Can you explain to do do the top suggestion?

AlB Member
Member
Posts: 184
Registered: ‎11-12-2018

Re: Need help ranking results for a Microsoft forum quiz

@abehrmann

 

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