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

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!

Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

wilson_smyth 

 

If you were using the Column OrderID from Table1, this simple measure would have sufficed

 

Measure = Calculate(sum(Table1[Quantity]),ALL(Table1[OrderLineID]))

i..e to you just wanted to sum for all Line IDs

 

but because you are using OrderID from Orders Table we needed to use VALUES(Table1[OrderID]) to hide the LineorderIDs which do not exist in Table1

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

    Thanks zubair_Mumammad. I understand this, but as my mode works by filtering and slicing using dimensions, this makes Table1 the fact table and i cant store slicable attributes in the fact.

     

    thsi is why i have a seperate orders dimension. but what i dont understand is, in the model i have, how the dax expression you wrote is interperted by the dax engine.