HELP MEASURE TO CALCULATE PRICE VARIANCE BY MULTIPLE FIELDS

[Anonymous]

Hello helpers,

Im relative new to PBI but facing a quite hard problems. I want to calculate price variances as below and summarise by Product, Account Code, Cost Code. I have just writed a measure like this:

TARGET PRICE VARIANCE = IF(OR([UNIT PRICE]=0,[SUM TARGET UNIT COST]=0),0,[SUM TOTAL VOLUME]*([UNIT PRICE]-[SUM TARGET UNIT COST]))

UNIT PRICE = [SUM TOTAL COST]/[SUM TOTAL VOLUME]

YOY UNIT PRICE = [YOY TOTAL COST]/[YOY TOTAL VOLUME]

The summarisation by Product get well as I expected, but when I summarised by Account Code and Cost Code not right.

I look forward to receiving your advise. Thanks for your attention

[v-yuta-msft]

@Anonymous ,

---

The summarisation by Product get well as I expected, but when I summarised by Account Code and Cost Code not right.

I look forward to receiving your advise. Thanks for your attention

---

 What's your expected result? The second table seems to be same with the first one. What does "summarised by Account Code and Cost Code" mean? 

Regards,

Jimmy Tao