Scoring quiz calculation

[Anonymous]

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! 

[amitchandak · Accepted 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