Running Total with Two Columns

[kirabray]

Hello!

I am having trouble writing the DAX for a running total of ordered units. I need to see them by date but also by customer. I have the DAX working for by date: 

Required RT = CALCULATE(SUM(FACT_Backorders[Order Quantity]),FILTER(ALL(FACT_Backorders[Delivery Date]), FACT_Backorders[Delivery Date] <=MAX(FACT_Backorders[Delivery Date])))

But when drilling down to customer I lose the running total:

Any advice on how to include customer so I will see a running total overall for the material? Thanks in advance!

[amitchandak]

@kirabray , Try to use the window function with partition by

Power BI Window function Rolling, Cumulative/Running Total, WTD, MTD, QTD, YTD, FYTD: https://youtu.be/nxc_IWl-tTc