Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Solved! Go to Solution.
@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
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
117 | |
109 | |
106 | |
92 | |
68 |
User | Count |
---|---|
167 | |
130 | |
129 | |
95 | |
91 |