Forum Discussion
Rolling sum without filter all function
Anonymous
You can change all() to ALLSELECTED()
Before not selected:
After the slicer is selected:
the ALL function ignores all filters, regardless of where they are coming from. In contrast, the ALLSELECTED function only ignores filters that are coming from the inner query.
This is the difference between all() and ALLSELECTED():
https://mitchellpearson.com/2020/09/14/understanding-row-context-in-dax-and-power-bi/
Best Regards,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Anonymous , have you tried a measure like
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD("Date"[Date ],MAX("Date"[Date ]),-12,MONTH))
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD("Date"[Date ],eomonth(MAX("Date"[Date ]),0 ),-12,MONTH))
tiill last month
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD("Date"[Date ],eomonth(MAX("Date"[Date ]),-1 ),-12,MONTH))