Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Scoring quiz calculation

Dear all, 

 

I am building a power bi dashboard for tracking quiz scores, the table looks as follows: 

 

Question nr. team 1team 2team 3team 4Round nr. 
1.233031
1.300331
1.433331
1.500331
1.633331

 

The values in the cells are scores per question. I would need to get the team name back in a card with the highest overall score (winner of the quiz). I tried to build a new table or with unpivoting the columns but I seem to have issues with the conditional part of the question. 

 

Could someone help me with this? 

Thank you in advance! 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Highest score by round, by overall etc

 

Once you unpivot teams, You can have Rank or TON by team

 

Or by Team/round and find the top

 

example

 

CALCULATE(max(Table[Team]),TOPN(1,allselected(Table[Team] ),calculate(sum(Table[score]))  ,DESC),VALUES(Table[Team]))

 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Highest score by round, by overall etc

 

Once you unpivot teams, You can have Rank or TON by team

 

Or by Team/round and find the top

 

example

 

CALCULATE(max(Table[Team]),TOPN(1,allselected(Table[Team] ),calculate(sum(Table[score]))  ,DESC),VALUES(Table[Team]))

 

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.