Calculating a Percentage to Capacity

[Anonymous]

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.

[AlfredvdM]

Where can I see the Solution?

[Anonymous]

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])

[Anonymous · Accepted solution]

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])