Measure to sum monthly capacity and usage

[Fiona83]

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 

https://drive.google.com/file/d/1WCf6YP8mE2BlSndGF92hrnZGQquKg6-1/view?usp=share_link

any help on this would be brilliant

Thank you

[Fiona83]

@Greg_Deckler 

Thank you for your reply!!

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

Updated file:

https://drive.google.com/file/d/1WCf6YP8mE2BlSndGF92hrnZGQquKg6-1/view?usp=share_link

[Greg_Deckler]

@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)
RETURN
  __Result