Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hey everyone!
I've got the following two DAX formula:
The Running Total Formula seems to ignore my filter.
Solved! Go to 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
)
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
)
@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)
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.
User | Count |
---|---|
47 | |
27 | |
23 | |
18 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |