Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Wrong sum

I have a shipment dataset that contains a Quantity (total ordered) and a Quantity Shipped column.

I have added a calculated column using DAX for Outstanding Quantity (Quantity - Quantity Shipped) and it is calculating correctly for individual rows.

For my selection of year and customer, the Sum of Outstanding Quantity is coming out to be wrong. I created a drill-through to see my rows and if you calculate the Sum of Outstanding Quantity manually, it is correct (correct outstanding quantity = 123). How do I reflect that correct amount on my line chart?

 

 

3 Replies