Sum of contract hours of a week with different Daily Hours

[Housden996]

Hi

I have an issue where I am trying to get the sum of a some what dynamic weekly value of contract hours for a clinet which has a contract structure as follows:

I also have some budgets which are only Mon-Fri or Sat-Sun.

I have managed to plot this into a line graph as well:

My issue is now when I try to sum the budget of the week multiplying the value of the contrtacted hours (Example):

Into a measure I get the following value:

Using the DAX:

mPro-Rate Hours = SUM('Pro Rate Budget'[Daily Hours]) * COUNT('Period File'[Date])

Question: How in dax would I do this to get the dynamic value of 1117 instead of 1611? This needs to scale up with the amount of days selected from a date / week commencing slicer. Also this needs to not multiply / add out the dates when mon-Fri or Sat-Sun clients arnt working or are working.

Data info:  

I am joing the Budget file to the date file using a middle table to trigger the working days for each contact as following:
Working Days Working Period * <-->* Pro Rate Budget Working Days

Working Days Value *<-->* Period File Day of Week

The working days table is as follows:

[amitchandak · Accepted solution]

@Housden996 , Try to use the date from the Working day  in a measure like

Sumx(values(WorkingDay[date]), calculate(SUM('Pro Rate Budget'[Daily Hours]) * COUNT('Period File'[Date]))  )