Need help with DAX running total by PO, reset count by PO

[tracyhopaulson]

Hello, I am trying to calculate the running total of Qty by POs (not PO lines) using DAX and cannot get it to work.

Here is my data sample and the result I need.  I'm new to Power BI so any help I can get is greatly appreciated.  Thanks

[HotChilli]

You can do this with a calculated column OR a measure but you need to add an Index (use Power Query Editor) because the DAX engine can't look at your data and decide how to order it without one.

Measure = CALCULATE(sum(TableTest[Qty] ), 
FILTER (
     ALL(TableTest),
     'TableTest'[PO] = MAX('TableTest'[PO]) &&
     'TableTest'[Index] <= MAX ( 'TableTest'[Index] )
))

I made the assumption that your real data has different PO values .

[tracyhopaulson]

Thank you for your help.  It makes sense to add the index column to create the grouping/ordering.  I tried the formula you suggested and received error "The MAX funtion only accepts a column reference as an argument".  Not sure what I missed!

[tracyhopaulson · Accepted solution]

Thanks HotChilli, the error is on my part.  This is working for me now.  Thanks again for your help with the formula 🙂