Forum Discussion
Post Patroncalculate total quantity for each order
Super Userwilson_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?
Post PatronApologies 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
Community Champion
This MEASURE works with your sample data.
Measure = CALCULATE ( SUM ( Table1[Quantity] ), ALL ( Table1[OrderLineID] ), VALUES ( Table1[OrderID] ) )- wilson_smyth
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
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
