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 all,
I currently work with 25 professional athletes, and I am trying to use Power BI daily to collect and visualise their GPS running data.
I have used a date table to create a measure that collects and organises the data into 'season weeks'. For example in week 20, Player A covered 30km while Player B covered 25km and Player C covered 27km.
When I try to visualise the the average distance covered by the entire team for a given season week, Power BI is taking an average of the daily amount each player has covered (each row in my dataset), rather than an average of the distance covered by each player in the given season week. For example, the average looks more like 5km rather than 28km.
If any one has any idea how to visualise an average value for a grouped data set that would be extremely helpful!
Kind regards
Hi,
Share some data to work with and show the expected result. Also, share a Calendar Table with a column of season weeks.
Hi, thank you for your reply:
Date table:
Example data is below. Over the course of the week, player A covered 28km, whereas player B covered 26km. On Power BI when I try to get the average of distance covered by the players in this week, the average should be 27km. Instead, Power BI is giving me an average of the distance covered in each day of the week, so between 3-4km in this example.
Day of Week | Distance Covered |
Monday | Player A = 4km, Player B = 3km |
Tuesday | Player A = 6km, Player B = 5km |
Wednesday | Both 0m |
Thursday | Player A = 5km, Player B = 4km |
Friday | Player A = 3km, Player B = 4km |
Saturday | Player A = 10km, Player B = 10km |
Sunday | Both 0m |
I am sure someone who can understand your reply will help you.
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 |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |