Forum Discussion
Solved
Correct Total for Averages (Price Volume Mix Analysis)
Hi, I am doing a price-volume-mix analysis and I am struggling to get a correct grand total. This analysis is done at a part number level (pbix link below) For simplicity, I am focusing just...
Hello carguello726 !
Can you share with us content of [Price Effect Measure]? I am struggling with same problem 😞
I understand the solution proposef by mahoneypat worked?
I have an issue - see that I can calculate Price effect indivudially on each Unit, but total is not correct. I think I should use SumX, but it does not work...
Total Price effect should be sum of -1.186 - 2.453 + 1.128 = -2.512
Here are Excel and PBI files:
I think I figured this out. I had to create two measures:
Price effect generic = ([Price Y+1]-[Price Y])*[Volume Y+1]
Price effect = sumx(values(Amounts[Unit]), [Price effect generic])
Works well with second formula 🙂 thanks for hint mahoneypat