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.
I have a data table that has the following columns: (work week), (condition pass), (team). There are multiple rows of the same work week, where each row is an instance of a condition passing or failing (1 or 0) and each row is associated with a team. There are multiple teams.
I want to plot the % of "condition pass" per week, where % of condition pass = sum of "condition pass per week"/count of teams/week.
My challenge is getting the "% of condition pass" by week and plot it by week. Everytime I add a new week (multiple rows of data for a week) to the data set, the values from the previous weeks change. How do I fix this problem?
Thanks
ssee
Hi @ssee
Please supply your data file, or at least a subset of dummy data that accurately represents its structure.
Regards
Phil
Proud to be a Super User!
Fundamentally if there are 100 rows in week 10/3/2022 and the sum of "qualified" in week 10/3/2022 is 10, then the % qualified is 10%. I need to plot the % qualified for each week and each week will have varying counts of rows.
Week | Team | Qualified |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 1 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/3/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 1 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
10/10/2022 | Team 2 | 0 |
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.