Forum Discussion
Cumulative Total with Max Date Filter
Hi I'm very new to PowerBi and need some help with the Cumulative Sum Dax formula. I have the following table of Measures created to show Cumulative Sales for current year (Actual), LY and Budget. ...
Hello,
Your cumulative measure should be something like this;
Cumulative Sales Amount = VAR _MaxDate = MAX ( 'Dates'[Date] ) VAR _Result = CALCULATE ( [Sales Actual], 'Calendar'[Date] <= _MaxDate ) RETURN _ResultThis is now solved. I changed from ALLSELECTED to ALL.
A similar issued was already solved in attached.
https://community.powerbi.com/t5/Desktop/Slicer-selection-changes-the-cumulative-total/td-p/655657.
I managed to solve this by changing from ALLSELECTED to ALL. My apologies, I should have reviewed existing forum posts more thoroughly. Thanks
avanderschilden
Resolver I
Resolver IHello,
Your cumulative measure should be something like this;
Cumulative Sales Amount =
VAR _MaxDate =
MAX ( 'Dates'[Date] )
VAR _Result =
CALCULATE ( [Sales Actual], 'Calendar'[Date] <= _MaxDate )
RETURN
_ResultThank you avendarschildren. I've tried your solution and it has worked!