Cumulative measure when using both a Date Dimension and Time Dimension

[daytek51]

I'm trying to create a cumulative measure for delivered tons in my model. I have a date dimension and a time dimension as we need it down to the hour. The issue I'm having is I can't figure out how to properly write the dax to cumulate across days, when the time dimension(hour) is placed. I need it to increment with each hour, but once it resets to hour 1 then next day, it also resets the cumulative tons. 

The measure needs to filter out loads that haven't yet been delivered which I have created a hour table with 25 values 24 being the null value in this case: 

This is the measure: 

Cumulative Tons =

VAR _datefilter =  FILTER(

        ALLSELECTED(DateDIm[Date]),

        DateDIm[Date] <= MAX(DateDIm[Date])

    )

VAR _hourfilter = FILTER(

        ALLSELECTED(HourTable[Hour]),

        HourTable[Hour] <= MAX(HourTable[Hour])

    )

VAR _completedfilter = CALCULATETABLE(

    cr7e8_dauberloads,

    _datefilter,

    _hourfilter,

    cr7e8_dauberloads[Hour] < 24  -- filter out loads that have not yet been delivered

)

RETURN

CALCULATE(

    SUM(cr7e8_dauberloads[deliveredTons]),

    _completedfilter,

    VALUES(stg_orders[dropOffLocation_name])

)

This is the results I'm currently getting but need it to keep summing across days 

Any help would be greatly appreciated.

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...