Total working hours per day/week/month per employee

[frank_becks]

I'm working on a report that displays the total capacity of employee hours per day/week/wonth etc. But having trouble summing the totals. What would be the best approache to get the correct totals for each levels calculated correctly? See the situation below:

The following tables are avalilable:

I've setup a date table and merged the employee- and schedules table to get this model:

Adding the fields to a Matrix gives me a correct total hours per day and week, but the totals per month and year are not summed correctly. 

[mahoneypat]

Please see this article.

Obtaining accurate totals in DAX - SQLBI

You likely want to use this pattern

NewMeasure = SUMX(VALUES(Table[FullName]), [YourMeasure])

Pat