Running Total with two filters not working

[jsims586]

I'm trying to calculate a running total of values for rows that only contain the specific text string of another column. Below is the formula I am using, but the results are just the totals for each month, instead of a cumulative total.

Filter EW Running Total = CALCULATE(SUM(GL_Detail[Gross_88ths_Value]),GL_Detail,CONTAINSSTRING(GL_Detail[AFE_Code],"EW"),FILTER(ALLSELECTED(Dates[Date]),ISONORAFTER(Dates[Date],MAX(Dates[Date]),DESC)))

[Sahir_Maharaj · Accepted solution]

Hello @jsims586,

Here's an updated formula that should give you the result you're looking for:

EW Running Total = 
VAR SelectedDates = ALLSELECTED(Dates[Date])
RETURN
    CALCULATE(
        SUM(GL_Detail[Gross_88ths_Value]),
        GL_Detail,
        CONTAINSSTRING(GL_Detail[AFE_Code], "EW"),
        FILTER(
            ALLSELECTED(Dates[Date]),
            Dates[Date] <= MAX(SelectedDates)
        )
    )

Let me know if you might need further assistance.