Calculate running total based on sales

[gwjjjjj]

Hi, I would like to calculate the running total based on the product sales.

Below is my sample dataset:

I want to calculate the running total in this order: group by product, and get total sales for each product. And calculate running total sales based on that.

I tried to use running total measure in power bi, but it doesn't work.

Does anyone happend to know the solution for this question? Thanks ahead.

[Anonymous]

Hi @gwjjjjj ,

You can try formula like below:

MEASURE =
VAR SUM_BY_Pro =
    CALCULATE ( SUM ( 'Table'[Sales] ), ALLEXCEPT ( 'Table', 'Table'[Product] ) )
RETURN
    DIVIDE ( SUM_BY_Pro, CALCULATE ( SUM ( 'Table'[Sales] ), ALL ( 'Table' ) ) )

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ryan_mayu]

@gwjjjjj 

you can try this

Measure = sum('Table'[Sales])

PROPORTION = [Measure]/CALCULATE(SUM('Table'[Sales]),ALL('Table'))

P2 =

var _PROPORTION=[PROPORTION]

RETURN CALCULATE([PROPORTION],FILTER(ALL('Table'[Product]),[PROPORTION]>=_PROPORTION))

[gwjjjjj]

That's works! One more question if you don't mind. If I have one more column called month. I want to add a month slicer, so user can check running total for different month. I try to use your method to do it, but it doesn't work.  Thank you so much for your help.

[ryan_mayu · Accepted solution]

@gwjjjjj 

pls see the attachment below