The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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 |
|---|---|
| 15 | |
| 8 | |
| 6 | |
| 6 | |
| 6 |
| User | Count |
|---|---|
| 23 | |
| 14 | |
| 13 | |
| 8 | |
| 8 |