cumulative sum is not getting correctly

[Anonymous]

GWP=if(CALCULATE(SUM('fact'[gross_premium]),FILTER('Calendar','Calendar'[Yr]=2021))= BLANK (),

0,

CALCULATE(SUM('fact'[gross_premium]),FILTER('Calendar','Calendar'[Yr]=2021)) )

Cumaltive=CALCULATE([GWP],FILTER(ALL('Calendar'),Calendar[date] <= MAX(Calendar[date])))

Any solution?

[amitchandak · Accepted solution]

@Anonymous , Try

GWP= CALCULATE(SUM('fact'[gross_premium]),FILTER('Calendar','Calendar'[Yr]=2021))+0

Cumaltive=CALCULATE([GWP],FILTER(ALL('Calendar'),Calendar[date] <= MAX(Calendar[date])))

or
Cumaltive=CALCULATE(SUM('fact'[gross_premium]),,FILTER(ALL('Calendar'),Calendar[date] <= MAX(Calendar[date]) && 'Calendar'[Yr]=2021))