Forum Discussion
Resource Work vs Resource Engagements
I am trying to understand my resource utilization. In my Project File, I can review the Resource Plan to see for the month of Oct-2020, for example, the resource Committed Work (Engagement), Resource Work, Committed Max Units (Engagement). This will help me to understand of the Committed Work (denominator) how much work is my resource actually assigned to (Project Work (numerator)). DAX would be something like: Utilization % = Sum('Table Needed'[Work Assigned to Tasks] * 100) / 'EngagementTimePhasedDataset'[CommittedWork] I thought this highlighted table above would be 'Assignments'[AssignmentWork], but this is calculating as a whole, rather than per month. Looking at the Project Resource Plan mpp file, for myself as an example, I can confirm what my numbers in Oct-2020 should read: Committed Work .....79.20 (correct) Work..............................79.25 (above [AssignmentWork]incorrectly showing 7.29) Committed Units........45% (correct) I can calculate that because my Committed work is 79.20 and my Work is 79.25 that my Utilization is equal to100.06% Where is my error here?
1 Reply
- TheoCCommunity Champion
Hi Anonymous
Can you provide a table that shows all of the data in your calculations? I cannot see where the 79.25 is in your table.
Also, is the 79.20 calculated or is it data in an existing column?
Thanks heaps,
Theo