Forum Discussion
Calculating a Percentage to Capacity
Hi All, I am attempting to calculate the percent to capacity my employees are in terms of reaching their capacity goals. I have a measure that uses a DISTINCTCOUNT to calculate how many jobs they...
Resolved - no further help needed.
Turns out I was trying to pull in a column from another table that was ultimately merged into my main table - so I needed to be using the merged field instead of the original. Calculation was very simple once that was sorted out:
%toCapacity = DISTINCTCOUNT(Table[Job_Number]) / AVERAGE(Table[Job_Capacity])
Where can I see the Solution?
Turns out I was trying to pull in a column from another table that was ultimately merged into my main table - so I needed to be using the merged field instead of the original.
Calculation was very simple once that was sorted out:
%toCapacity = DISTINCTCOUNT(Table[Job_Number]) / AVERAGE(Table[Job_Capacity])