Forum Discussion
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.
3) Divide Attendance to Medals.
Thank you in advance.
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 youRegards,RiteshRegards,Ritesh
5 Replies
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 😀
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 youRegards,RiteshRegards,Riteshspeedramps 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.
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.
