Cumulative sum shows blank values

Hi Anonymous ,

 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

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

Hi Anonymous 

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.

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