Cumulative sum shows blank values

[Rovshan-Hasanov]

I have a measure that sums all debit transactions: 

I also have a measure that is supposed to find cumulative sum based off of the first measure:

However, when there is no debit transaction in a given month, cumulative sum returns blank:

It is supposed to return cumulative sum of all debit transactions that happened before or on the last day in a given context 

[Rovshan-Hasanov]

thank you for your reply. turns out that problem stems from data connection. it was set to both way. i needed it that way for another reason so needed to change the measure to include CROSSFILTER to change the direction for this case

[danextian · Accepted solution]

I set it to both and still using the same formula. Cumulative sum still returns correctly.

[danextian]

Hi @Rovshan-Hasanov 

You're making a cumulative sum on the Date dimension instead of the whole calendar table so the ALL context is applied to that dimension only. Apply it to the whole of the table instead.

[Rovshan-Hasanov]

i have tried that. in that case, cumulative measure returns  0, which is still not i want. put it differently, i want it to carry forward the previous period's number when there is no transaction in the current period

[djurecicK2]

Hi @Rovshan-Hasanov ,

 This behavior is by design. In order for the cumulative measure to return a non-blank value, you need to return 0 instead of blank with the original measure. You can accomplish this by using a combination of IF and ISBLANK: 

https://learn.microsoft.com/en-us/dax/isblank-function-dax