Forum Discussion
KarlNixon
Advocate I
Advocate IRunning Total sales orders by customer
Looking for brainstrust help. I am looking to create a calculated column showing the running total of sales orders by customer. For example the calculated column below [Nth Sales Order by Cus...
Found the solution
Change the Filter to FILTER(ALLEXCEPT(sales, sales[order number]))
amitchandak
Super User
Super UserI 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.
KarlNixonAdvocate I
Advocate IFound the solution
Change the Filter to FILTER(ALLEXCEPT(sales, sales[order number]))
- v-eachen-msft
Community Support
