Forum Discussion
Cumulative Total with Max Date Filter
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
This 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