Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have a data set with person number, week number, and hours worked for that day. I'm trying to calculate the average number of hours per week each employee worked, and then be able to group the COUNT of personIDs with the same number of average number of hours worked. Essentially answering the question, how many employees worked an average of 8 hours per week.
I was able to calculate the average number of hours per week per employee, but when I tried to map it to a table with count of person ID it did not work at all.
My calculation for average hours per weeks looks like this...
PersonID | WeekNumber | HoursWorked |
0023 | 1 | 8 |
0023 | 1 | 6 |
0023 | 4 | 9 |
0023 | 4 | 4 |
0023 | 6 | 2 |
0023 | 6 | 6 |
0023 | 6 | 6 |
0023 | 6 | 3 |
0025 | 1 | 8 |
0025 | 1 | 6 |
0025 | 4 | 4 |
0027 | 4 | 2 |
0027 | 4 | 5 |
0029 | 2 | 7 |
0029 | 2 | 8 |
0029 | 6 | 2 |
Hi, unfortunately a measure can't be used in the same way as a column. In this case I suggest that you create a new calculated table with the average hours by PersonID. You can do that by wrapping your own measure in a SUMMARIZE like this:
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
20 | |
18 | |
17 | |
16 |
User | Count |
---|---|
37 | |
20 | |
19 | |
17 | |
11 |