Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Perfomance Question

Hi everyone,   I want to find the performance of a team with using these columns below. These are my questions; 1) Count how many times the team attend to the games. 2) Count the medals earned. ...
Need Help
  • ribisht17's avatar
    ribisht17
    4 years ago

    Anonymous 

     

    Are you looking for each country's Participation in the View itself?

     

    Teams Attented Count = COUNTROWS(FILTER(all('Olympic Medals'),'Olympic Medals'[Country]=max('Olympic Medals'[Country])))
     
    If you are looking for the overall then the above answer is the one for you
     
    Regards,
    Ritesh
     
    Regards,
    Ritesh
speedramps's avatar
speedramps
Super User
4 years ago

Attendance =

COUNTDSITINCT(yourtable[year])

 

Medals =

SUM(yourtable[gold])+ 

SUM(yourtable[silver])+ 

SUM(yourtable[bronge])+ 

 

MedalsvAttendance =

DIVIDE( Medals,Attendance )

 

I helped you now please help me with kudos.

Please click thumbs up and accepts as solution buttons.

One problem per ticket please.

If you you need to revise the problem then please accept this solution and raise a new ticket. 

Thanks 😀