Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • TheoC's avatar
    TheoC
    Community 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