Forum Discussion

wilson_smyth's avatar
wilson_smyth
Icon for Post Patron rankPost Patron
7 years ago

calculate total quantity for each order

  I am trying to calculate the total quantity of items on all lines of an order. So each line will show the quantity for the orderline, and the total order quantity. Model is simple, an order dime...
Need Help
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

wilson_smyth 

 

This MEASURE works with your sample data.

 

Measure =
CALCULATE (
    SUM ( Table1[Quantity] ),
    ALL ( Table1[OrderLineID] ),
    VALUES ( Table1[OrderID] )
)
wilson_smyth's avatar
wilson_smyth
Icon for Post Patron rankPost Patron
7 years ago

thank you, this does work!
I need to understand it so that i learn from this.
Could I ask for an explaination how the dax engine interperts this measure?

 

Thank you for your help!