Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Anonymous
Are you looking for each country's Participation in the View itself?
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.
@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.
@Anonymous
Are you looking for each country's Participation in the View itself?
Thank you very much.
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 😀
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |