cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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 3
Regular Visitor

Where can I see the Solution?

Anonymous
Not applicable

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
Not applicable

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

Announcements

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors