Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |