Forum Discussion
Measure total is not correct
Hi, Need some help and yes I know there are a dozen of threads for this same exact issue, but whatever I am doing in relation to those answers isn't working for me. My measure is the followin...
What is it summing too? The average of all prices times the sum of all out of stock instead of the individual lost sales?
I’m not at office, but probably needs to be an iterator or calculate statement in the lost sales. Try wrapping it with calculate or sumx instead of just adding the measures together. You want to force it to go row by row multiplying then adding, not taking the grand totals and multiplying.