Labor Utilization Issue

[Anonymous]

I have been struggling to get my utilization to cooperate. What I am looking for is (total billed hours)/(available hours), where available hours is 40/week. However, I need to be able to drill up and down by month, week, date, and filter by title, project, and employee. I have tables for employees, billed hours, projects, and dates. My current DAX for available hours is what I think is messing me up: 

CALCULATE(SUM('Date'[Hours]),'Date'[Week Day]=1)*CALCULATE(DISTINCTCOUNT('Persons'[Person_ID]),USERELATIONSHIP('Billed_Hours'[Project_ID],Projects[Project_ID]))

While this works on a daily and employee level, this doesn't work for monthly or weekly or at a complete project level. I think this is because the number employees can change during that time, and rather than adding the available hours, it is assuming hours for all employees who ever worked on that project/month/week. 

 Project aggregate - shows 6 employees, but that is the max across the project. There was never more than 3 people at any given time. 

Weeky/daily breakdown - the weekly is incorrect, and should be 104 available hours and 100% utilization. 

Can anyone help? Thanks! 

[Anonymous]

@amitchandak  @Idrissshatila @olgad I see you all are top contributors. I'm desperate - can any of you help? 

[Anonymous]

Bump. I could really use some help!