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 currently have on their plate, but am not able to to get the % of jobs to job capacity they currently sit at. The Job Capacity metric is its own column, and a single person only has one Job Capacity goal (despite it being listed in every row that they are listed in). See below for sample table - any thoughts on a simple fix? The output for the below should have John at 60%, Beth at 100%, and Larry at 25%.
| Name | Job Number | Job Capacity |
| John | 1356 | 5 |
| John | 4532 | 5 |
| Beth | 6753 | 3 |
| Larry | 2235 | 4 |
| Beth | 7864 | 3 |
| John | 4544 | 5 |
| Beth | 7667 | 3 |
Thanks in advance! much appreciated.
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])
3 Replies
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])
