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

One problem per ticket please. ☹️
I answered your question.

If you you need to revise the problem then kindly please accept this solution and raise a new ticket. 
Don't change the problem and expect eagerness to help if you don't accept solutions.

Thanks for your understanding.