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
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