Cumulative not carrying over when no purchase

[corange]

Hi everyone, 

I am struggling with one of my report. I don't understand why it is not showing up the right results. 

I need to calculate points accrued for a client. Points are accrued each month and carried over if any left. 

For this, I have used a cumulative measure as follows: 

Cumulative Points = IF(ISBLANK(SUMX(test1,test1[Nber of Job])), BLANK(), CALCULATE(SUMX(test1,test1[Nber of Job]),FILTER(all('Calendar'),'Calendar'[SingleDate]<=max('Calendar'[SingleDate]))))

Then I use the following to know how many vouchers I need to give away (1 voucher for every 150 points). 

Tickets Current = QUOTIENT([Cumulative Points],150) 

To know exactly how many voucher I need to give for any given month, I deduct the number of voucher they have received the previous month as I use a cumulative measure to make sure I take into consideration carry over points. 

Ticket to get = ([Tickets Current]-[Tickets Last Month])

**Tickets last month = (CALCULATE([Tickets Current], DATEADD('Calendar'[SingleDate], -1, MONTH)))

The below are the results I obtained:

I don't understand why the cumulative is not showing up for Jan. The client didnt make any purchase that month but I thought it will still carry over? Also I don't understand the -18 in Jan or 18 in March. With the cumulative results adding up for January even thought the client didnt purchase, will give me the right results for the voucher. 

Can someone please help with the formula to fix this? 

You can access the pbix file here if that can be useful: https://1drv.ms/u/s!AiS7XVNuQsBCfLR3YfEnr4wJxEo?e=fM0NE4 

Thank you. 

[Ashish_Mathur · Accepted solution]

Hi,

Is this the result you are expecting?  Download the PBI file from here.

[corange]

Hi Ashish, 

Thank you so much. Exactly what I was after. 

Thanks. 

[Ashish_Mathur]

You are welcome.

[synergised]

This might get you a little further.

1.  Calendar - mark this as a date table

2.  Sample formula

Cumulative_Actual =

CALCULATE (

SUM ( 'Client'[Nber of Job] ),

filter( ALL ( 'Calendar' ),

'Calendar'[SingleDate] <= MAX( 'Calendar'[SingleDate] ))

)