Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Max Medals earned

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.

 

 

Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    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.

5 Replies

  • v-kkf-msft's avatar
    v-kkf-msft
    Community Support
    4 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      The player with the most medals.

      Ty.

      • Vijay_A_Verma's avatar
        Vijay_A_Verma
        Most Valuable Professional
        4 years ago

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