Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a measure which calculates Hours Worked each month ... so for January each person has worked 155 hours. I am trying to figure out how to make the Manager's result a total rollup of all of the supervisors under them. So for this example, for January I would want the manager's result to be 775.00 instead of showing their own result of 155. Is there a DAX code I could use for this or some other way to format the table so that it rolls up? Thank you.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
53 | |
34 | |
17 | |
17 | |
15 |