Forum Discussion
Rolling sum without filter all function
Hi all,
Having some problems with my rolling sum function below, I have slicers on the page so when I use the Filter(ALL( function it removes the interaction with the sliders. Is there anyway to calculate rolling sums without FILTER(ALL)?
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
2 Replies
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))
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
