Cumulative Totals not working in the visualization

[stewbel]

I have a cumulative total for hours over time :

Cumulative_Hours = CALCULATE(

  SUM(QryTimesheets[Labor Hours]), FILTER(ALLSELECTED(QryTimesheetS), QryTimesheets[PA Period End Date]<=MAX(QryTimesheets[PA Period End Date])))

This works great if my slicer for selecting data is either Infrastructure, OR PM hours. If both categories are included in the visual, then I get the running sum for the entire table for that time slice. This matters as I want to display a cumulative chart with lines for both infrastucture and PM cumulative hours. Thanks in advance

[stewbel]

Fantastic - thank you so very much

[Jihwan_Kim · Accepted solution]

Hi,

I do not know how your semantic model looks like, but please try something like below whether it suits to solve the issue.

Cumulative_Hours =
CALCULATE (
    SUM ( QryTimesheets[Labor Hours] ),
    FILTER (
        ALLSELECTED ( QryTimesheetS ),
        QryTimesheets[PA Period End Date] <= MAX ( QryTimesheets[PA Period End Date] )
            && QryTimesheets[GRP] = MAX ( QryTimesheets[GRP] )
    )
)