Forum Discussion
Advocate IRunning Total sales orders by customer
Found the solution
Change the Filter to FILTER(ALLEXCEPT(sales, sales[order number]))
Super UserYou can use a quick measure. Right-click on table or measure. Click on quick measure.
Or refer to this
https://community.powerbi.com/t5/Desktop/Cumulative-Total/td-p/43115
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case this not working, please mark my @ username in reply.
Thanks.
- KarlNixon
Hi amitchandak,
Almost gets there - but this gives a running totalfor all values - I'm after a running total for each customer in the data set.
for example for the first sale for Tom, James and Sam they would have the number 1 and for each subsequent sale, 2,3....
Thoughts?
- amitchandak
I think you need cummlativesub totals
https://community.powerbi.com/t5/Desktop/Calculating-Cumulative-Monthly-Totals/td-p/100756
https://community.powerbi.com/t5/Desktop/Subtotal-YTD-in-Matrix/td-p/324239
https://community.powerbi.com/t5/Desktop/Cumulative-Running-Balance-in-a-Matrix/td-p/490907
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
Thanks.- KarlNixon
Found the solution
Change the Filter to FILTER(ALLEXCEPT(sales, sales[order number]))