PowerPivot DAX - Wrong SubTotals

[man0s66]

Hi all,

I'm trying to create a summary of expected hours based on each employee's weekly contract hours and project this only for working days during each month,week,day.

My DAX is like :SUM_WDPerWeek:=IF(MAX('Calendar'[NetWorkingDays])=0,0,CALCULATE(
SUM([NetWorkingDays]),
FILTER(
ALLSELECTED('Calendar'),[Date]),'Calendar'[NetWorkingDays]=1))

My problem here is that :
1. The subtotals (for working days and working hours) are showing the grant total instead of the correct split.
2.How can i calculate the daily workload of each employee(based on their weekly load) and then then multiply it per working day, in order to get the daily sum?

Thanks in advance for any suggestions!

[JeteMc]

Assuming that the issue is with columns N:O, I am not sure what your expected results should look like.
Perhaps if you could display manually calculated results for a couple of weeks it would give someone a better idea of how to help.
Let us know if you have any questions.