Values measure to roll up with Date Heierarchy

[ctedesco3307]

Hello -  I have a table that has a start date and end date and total hours per role per project.

 I have a measure that calculates the number of working days between the start and end date

MSSWorkingDays =

CALCULATE (

    SUM ( TDate[Tworkday] ),

    FILTER (

        TDate,

        TDate[Date] >= MIN('MSS Flat Fee Hours'[Start Date])

            && TDate[Date] <= MAX ( 'MSS Flat Fee Hours'[End Date])

    )

)

I have another measure that gives me the average hours per day based on number of days / total hours.

MSSPlanHoursPerDay =

DIVIDE(SUM('MSS Flat Fee Hours'[Total Hours]),[MSSWorkingDays])

Works  in a table, but what I want to do is show the average number of hours as my values using my calendar table year> Month>week> day … as the columns summing up per date level  - I  can’t get the values to roll up right with my calendar table. It looks like both the MSSPlanHoursPerDay and Plan hours are behaving the same, but descreasing as I roll up, and increasing as I roll down.  Also I can’t seem to get the values with the calendar column to align with the start and end dates of the project.   Please let me know what add’l info needed. Thank you much in advance!

These values are correct

But using my calendar dates in a matrix doesn’t add up right start and end months don’t line up with start and end dates and values are not summing correctly and decreasing instead of increasing

Month

Week

Date

How do I sync them up? Thanks in advance 

[vapid128]

That is a hard problem. 

Can you upload your file?

I can try.