Filtered Dax not showing correct result

[Anonymous]

Hey everyone!

I've got the following two DAX formula:

UPO Downloads = COUNTROWS('OD - UPO Downloads')

Running Total UPO Downloads = var maxDate = MAX('Dates'[Date]) return CALCULATE( 'OD - UPO Downloads'[UPO Downloads], REMOVEFILTERS( 'Dates'), 'Dates'[Date] <= maxDate)

And I've got the following filter and card:
The Running Total Formula seems to ignore my filter.
So my question is: How can I make my Running Total Formula work in combination with the filter?

[tamerj1 · Accepted solution]

Hi @Anonymous 

please try

Running Total UPO Downloads =
VAR maxDate =
    MAX ( 'Dates'[Date] )
VAR minDate =
    MINX ( ALLSELECTED ( 'Dates' ), 'Dates'[Date] )
RETURN
    CALCULATE (
        'OD - UPO Downloads'[UPO Downloads],
        REMOVEFILTERS ( 'Dates' ),
        'Dates'[Date] <= maxDate,
        'Dates'[Date] >= minDate
    )

[Greg_Deckler]

@Anonymous Well, yes, you used REMOVEFILTER so that is going to blow away all filters on that table. Try:

Running Total UPO Downloads = 
var maxDate = MAX('Dates'[Date]) 
var minDate = MIN('Dates'[Date]) 
return CALCULATE( 'OD - UPO Downloads'[UPO Downloads], REMOVEFILTERS( 'Dates'), 'Dates'[Date] <= maxDate, 'Dates'[Date] >= minDate)

[Anonymous]

Hey Greg,

I've tried your Dax formula, but that one returns only the amount of downloads of the last day. (31-3-2022) 
Instead of a running total of the entire period.