Cumulative sum of measure

[Dunner2020]

Hi there,

I have a monthly average measure that calculates the average based on the month which looks like as follow:

Average Monthly = if(ISBLANK([sum_measure]),BLANK(),AVERAGEX(ALL(Dates[RY Year]),[sum_measure]))

I created another measure that calculates the cumulative sum of the average monthly measure

Cumulative sum = CALCULATE(SUMX(VALUES(Dates[RY Month Number]),[Average Monthly]),

FILTER(ALLSELECTED(Dates),Dates[RY Month Number]=MAX(Dates[RY Month Number])))

However, it does not produce the desired output. Following is the output generated by above-mentioned measures:

Could anyone guide me where I made the mistake?

[amitchandak · Accepted solution]

@Dunner2020 , Try <=, if that is not a typo

Cumulative sum = CALCULATE(SUMX(VALUES(Dates[RY Month Number]),[Average Monthly]),
FILTER(ALLSELECTED(Dates),Dates[RY Month Number]<=MAX(Dates[RY Month Number])))