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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

speedramps thank you for your quick reply, your answer is correct but my model is wrong 🙂

Actually it is not the way measuring the performance i need to add players here and count players and then filter by country and finally find the performance ratio.

so let me revise the table like below;

Bottomline, i want to see the Country performance.