https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Roll-up-a-Measure-to-the-top-Row-of-data/m-p/3150397#M112830 <P><img /></P><P>&nbsp;</P><P>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.</P> Thu, 23 Mar 2023 15:30:19 GMT Anonymous 2023-03-23T15:30:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Roll-up-a-Measure-to-the-top-Row-of-data/m-p/3150397#M112830 <P><img /></P><P>&nbsp;</P><P>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.</P> Thu, 23 Mar 2023 15:30:19 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Roll-up-a-Measure-to-the-top-Row-of-data/m-p/3150397#M112830 Anonymous 2023-03-23T15:30:19Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Roll-up-a-Measure-to-the-top-Row-of-data/m-p/3153972#M113069 <P>Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot). <BR /><A href="https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216</A> <BR />Please show the expected outcome based on the sample data you provided. <BR /><BR /><A href="https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523" target="_blank">https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523</A></P> Sat, 25 Mar 2023 18:01:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Roll-up-a-Measure-to-the-top-Row-of-data/m-p/3153972#M113069 lbendlin 2023-03-25T18:01:46Z