Forum Discussion
Scoring quiz calculation
Dear all,
I am building a power bi dashboard for tracking quiz scores, the table looks as follows:
| Question nr. | team 1 | team 2 | team 3 | team 4 | Round nr. |
| 1.2 | 3 | 3 | 0 | 3 | 1 |
| 1.3 | 0 | 0 | 3 | 3 | 1 |
| 1.4 | 3 | 3 | 3 | 3 | 1 |
| 1.5 | 0 | 0 | 3 | 3 | 1 |
| 1.6 | 3 | 3 | 3 | 3 | 1 |
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!
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
1 Reply
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