Running total on stacked column chart - show 0 where blank or previous value by category

[Anonymous]

Hello everyone,

Have anyone faced with Running total calculation problem in Stacked column when it's showing 0 by category in columns where blank or previous value

Find full description by link https://community.powerbi.com/.../Running.../m-p/186401...

I have faced with same problem, and couldn't find the right solution,

I would be very thankful for sharing your experience

[amitchandak]

@Anonymous ,Have tried running total with help from date table.

example: Cumm Sales = CALCULATE(SUM(Sales[Sales Amount]),filter(allselected(date),date[date] <=max(date[Date])))

[Anonymous]

@amitchandak Hello Amit, do you know how to solve it? I really need this and honestly have no clue how to solve this inconvenience?

[Anonymous]

@amitchandak Yes I'm using the exact same measure in my report: Actions YTD = CALCULATE([Total];FILTER(ALLSELECTED(Action_Log[Mon-Year]);Action_Log[Mon-Year] <= MAX(Action_Log[Mon-Year])))

But when I put it in stacked column chart by category I get the situation where for last month I don't have one of the 3 category because at that month there wasn't any data related to that category. What I want is to have the same amount for that category as in previous month in such case. Insteaed I get only 2 category out of 3.

I don't know how to solve it, 

Maybe you have any ideas