running sum of a measure

[Jacques_N]

Hello to all,

In order to affect a class to a product I need to make a running total of a sorted table:

Whath I have in power bi are the colums in green (of course unsorted I did it in excel), an what I would like to get is the runing sum in red colum, and that for one key. As soon as the key change power BI has to restart the process.

Thanks for your help.

Regards

Jacques

[v-juanli-msft · Accepted solution]

Hi @Jacques_N

Assume [weight] is a column

create a measure as below

running sum = CALCULATE(SUM(Sheet1[column]),FILTER(ALLEXCEPT(Sheet1,Sheet1[key]),[plant]>=MAX([plant])))

Assume [weight] is a measure

create a measure as below

running sum 2 = SUMX(FILTER(ALLEXCEPT(Sheet1,Sheet1[key]),[plant]>=MAX([plant])),[Measure])

Best Regards

Maggie

[Jacques_N]

Hi Maggie,

Thanks a lot, basically taht working very well, with a limited extraction of my database. But my whole dataset is nealy 1.5 M rows, and then I get "Not enough memory".

I will try to separate this calculation in a separate powerBI .

Thanks a lot,

Jacques