Total in matrix table not adding up the correct amount

[Anonymous]

Hi, 

I have created a column that calculates the time between my task's start and finish times. Then, for my matrix table, I created a measure for it as below:

_SumTaskTime = CALCULATE(SUM('FinanceTimeLog (2)'[DurationofTask]), FILTER(DateTable, DateTable[Date]))

The idea is that it totals the amount of time spent on each task, filtered by date. The measure itself is working, but my mtarix table's 'total' is not for some of my columns. Attached for your reference.

Could you please advice as I am not sure why it is working for some only? Thank you 

[amitchandak]

@Anonymous , the filter function seems incomplete. Can you correct this

_SumTaskTime = CALCULATE(SUM('FinanceTimeLog (2)'[DurationofTask]), FILTER(DateTable, DateTable[Date]  ?? ))

[Anonymous]

Thank you, I have updated the dax but the issue is with the built in 'Total rows' where it is not adding up the correct amount for some columns. I am not sure how to fix that?

[Anonymous]

Also to add, it only happens when I change the date range to a longer period. If the date range from my slicer is a few days then it seems fine but if I keep going further, it brings random figures