Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Frequent Visitor

Measure to sum monthly capacity and usage

Hi There

I urgently need help with this


I am trying to figure out how to show how much each person is being utilized every month out of their total capacity in a stacked graph.


I have appended query showing

Yellow - how many days each week a person is booked on a project (allocated)

Blue - How many days they are available that week (capacity)





I think I need to add a measure, but not sure what calculation will work.


No 1 is my primary visual showing all allocated, but when I filter this by date my 2nd visual aligns to allocated and removes the capacity. Ideally, i would like this 2nd visual as a stacked graph but haven't been able to make that work 




any help on this would be brilliant


Thank you

Frequent Visitor



Thank you for your reply!!


Not sure what's going wrong., but it's not working correctly...


Updated file:



Super User
Super User

@Fiona83 Seems like it should be something along the lines of:

Utilization % = 
  VAR __allocated = SUMX(FILTER('Table',[Source] = "allocation"),[Days])
  VAR __capacity = SUMX(FILTER('Table',[Source] = "Capacity"),[Days])
  VAR __Result = DIVIDE(__allocated, __allocated + __capacity,0)

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors