Measure for cumulative sum

[JC2022]

Hi,

I have some trouble with creating a measure. I have the fields below from 2 tables. Date and MonthYear from a calendar table. The other columns are from a different table with obviously a relationship between Date columns.

Now I am trying to create a cumulative sum measure of the "Hours to do per workday". But this measure should be able to filter on a speficic Category, Team and Project. But when removing a (for example) Team filter it should cumulate the sum per Category. And when removing the Category and Team it should cumulate the sum per Date. Etc. 

So on the 09/07/2024 date it should be the sum of 08/07/2024 and 09/07/2024 together. For the Categories, Teams and Projects. How can this be done in a measure?

Is anyone able to help me? 

Row Labels8-7-20249-7-202410-7-2024Grand TotalCategory A0,900,900,902,70Team A0,900,900,902,70Category B1,651,651,654,95Team D0,850,850,852,54Team I0,800,800,802,41Category C6,716,715,9319,35Team B1,751,750,974,47Team C0,760,760,762,29Team E1,761,761,765,27Team F0,840,840,842,52Team G0,800,800,802,40Team H0,800,800,802,40Grand Total9,269,268,4827,00

GH761008	0,90	0,90	0,90	2,70
GH760640	0,85	0,85	0,85	2,54
AT511552	0,80	0,80	0,80	2,41
AT511637	0,97	0,97	0,97	2,91
GH760885	0,78	0,78		1,56
AT510847	0,76	0,76	0,76	2,29
GH760243	0,90	0,90	0,90	2,70
GH760809	0,86	0,86	0,86	2,57
GH760619	0,84	0,84	0,84	2,52
GH760854	0,80	0,80	0,80	2,40
GH760556	0,80	0,80	0,80	2,40

[bhanu_gautam · Accepted solution]

@JC2022 , Try using below mentionedmeasure

CumulativeHours =
VAR CurrentDate = MAX('Calendar'[Date])
RETURN
CALCULATE(
SUM('WorkData'[HoursToDoPerWorkday]),
FILTER(
ALLSELECTED('Calendar'),
'Calendar'[Date] <= CurrentDate
)
)