Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |