topic Re: Running total on stacked column chart - show 0 where blank or previous value by category in DAX Commands and Tips

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

Anonymous — Tue, 16 Mar 2021 13:32:36 GMT

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

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

amitchandak — Tue, 16 Mar 2021 15:03:41 GMT

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])))

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

Anonymous — Tue, 16 Mar 2021 15:51:39 GMT

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

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

Anonymous — Wed, 17 Mar 2021 13:36:37 GMT

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