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?

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 105 members 1,109 guests
Please welcome our newest community members: