Sum of column by date not working

[kiserr]

I have a matrix and have added 'Dates[Weekending] as Columns (filtered by nest 12 weeks).  However, when i add the Remaining Hours field in the Values area and select Sum, the result is incorrect.  It should be 51302 for 5/7/23 but is coming as 182544.  The sum of budgeted hours appears correct.  

DatesTable - containts dates column and weekending column

Schedule Raw Data - Unique field is activity id.  it contains budgeted hours, actual hours and remaining hours but not by specific weekending.

Budgeted Hours = activity Id is related to activity id in Raw schedule.  Date is related to Date in Weekending table.  This table contains budgeted hours for the specific week and specific activity id.  the dates in this table were originally in columns.  So, they have been unpivoted.

Remaining hours table - activity id related to activity id in raw data and dates tied to dates in weekending.  this table contains remaining (scheduled) hours for the specific date by activity id.  the dates in this table were originally in columns.  So, they have been unpivoted.

I have tried using the Dates field from the Remaining Hours table.  The result is less than it should be (24315).

I have tried using a measure (Remaining Hours = SUM('Remaining Units by ACTNO'[Remaining Early Hours])).  results are identical to just using the regular sum on the value.

I don't see that I can upload my pbix.  

[v-zhangti]

Hi, @kiserr 

Can you provide more sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel. I look forward to your response.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.