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
ribisht17's avatar
ribisht17
Super User
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

    Thank you very much.