Forum Discussion
Summed average doesn't add up
I've got a table like above. I want to take the average of each PDPartLineNr and sum that average. The total here should be 65000, but it is 77500. This is my measure. It works for most of my cases, but some are wrong and I don't get why.
Ordered QTY Measure =
SUMX( VALUES(Delivery[PDPartLineNr]),
AVERAGE(Delivery[Ordered_QTY]))
Anonymous , add calculate and try
Ordered QTY Measure =
SUMX( VALUES(Delivery[PDPartLineNr]),
calculate(AVERAGE(Delivery[Ordered_QTY])) )
2 Replies
Anonymous , add calculate and try
Ordered QTY Measure =
SUMX( VALUES(Delivery[PDPartLineNr]),
calculate(AVERAGE(Delivery[Ordered_QTY])) )