Max Medals earned

[Anonymous]

Hi everyone,

Could you please help about the maximum medalist for the table below? (Just an example table)

Medals # is created by me.

ty in advance.

[v-kkf-msft · Accepted solution]

Hi @Anonymous ,

Please try the following formula and filter.

Caluculated column:

Medals # = IF ( [Medals] in {"Gold", "Bronze", "Silver"}, 1, 0 )

Measure:

Rank = 
RANKX (
    SUMMARIZE ( ALLSELECTED ( athlete_events ), athlete_events[Name] ),
    CALCULATE ( SUM ( athlete_events[Medals #] ) ),
    ,
    ASC,
    DENSE
)

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Vijay_A_Verma]

What is the output expected?

[Anonymous]

The player with the most medals.

Ty.

[Vijay_A_Verma]

if a player wins 4 medals, say 2 Gold, 1 Silver and 1 Broze, will there be 4 lines items for him or 1 for Gold which will have medals # as 2, 1 for Silver and 1 for Broze?

Actually, in your example table, it is no clear...

[Anonymous]

The breakdown for the medals is not important, so gold silver bronze doesnt matter.

I just want to make a card with the athlete with most Medals.