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
parry2k's avatar
parry2k
Icon for Super User rankSuper User
7 years ago

wilson_smyth i looked at your pbix but not fully clear about your requirement, can you put what your expected result is based on pbix you shared and where you see the issue?

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