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 ...
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
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