Forum Discussion
Sum by year
Dear Friend, i have two tables, data(value,id,..) and calendar(date,year,quarter) and are related one to many . i have date slicer between and calculated profit by measure: var date_min=CALCULATE...
This bit is not behaving as you're expecting:
ALL('Calendar'[Date])
It only removes filters directly applied to that column. If the quarter or year columns are filtered, it will do nothing. I recommend replacing it with ALL('Calendar'). You are not alone in having this issue. Here's someone else having a similar problem:
https://community.fabric.microsoft.com/t5/Desktop/Cumulative-sum-with-Date-Hierarchy/m-p/797893