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
wilson_smyth's avatar
wilson_smyth
Icon for Post Patron rankPost Patron
7 years ago

Apologies for the lack of clarity, I have updated the original post with a screenshot of the report & two points explaining the issue with it that i am stuck on.


Please let me know if there is enough information here as i can add whatever is required.

Thanks

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] )
)