Cumulative sum has strange behavior on table with other columns

[PersephoneK]

Hello, I just created a "cumulative total" column and it works fine when I add it to a table with just the dates and the original total values (by date). But when I add another column that is a completely different metric, the cumulative metric gives the same value as the original total value.  See screenshots below of the two versions of the table (with and without the extra column (Total Time).  I have one page level filter applied in the filter pane, and a Year filter applied for the page (top corner slicer). 

This is the formula for my Cumulative total: 

Distance Cumulative = CALCULATE(Data_Master[Distance Total], FILTER( ALLSELECTED( Data_Master[Date] ) , 'Data_Master'[Date] <= MAX('Data_Master'[Date] )))

Any help would be appreciated! Thank you!

[johnt75 · Accepted solution]

I think that the Time is being added to the filter context, try removing that filter like

Distance Cumulative = CALCULATE(Data_Master[Distance Total], REMOVEFILTERS(Data_Master[Time in hours]), ALLSELECTED( Data_Master[Date] ) , 'Data_Master'[Date] <= MAX('Data_Master'[Date] ))

[PersephoneK]

That worked brilliantly! Thank you!