Total Profit by SKU and the aggregate profit based on Qty sold.

[ridho72]

Hi ,

I encounter an issue for getting Total profit using data from

Sales price per unit

SP/kg = 

DIVIDE(SUM('Penjualan'[Total]), SUM('Penjualan'[Qty]),0)

COGS per unit + Other Cost

HPP per kg plus OtherCost =
[HPP per kg All] + SUM('OtherCost'[OtherCost])

Profit per unit

Profit per unit = [SP/kg]-[HPP per kg plus OtherCost]

Total Profit

Total Profit =
([SP/kg]-[HPP per kg plus OtherCost])*SUM(Penjualan[Qty])

The problem lies according to picture. I have 3 main products in which the Total Profit amount is correct but the aggregate amount does not tally.

Please help

[v-yuta-msft]

Hi ridho72,

Please check if you have built a relationship between 'Penjualan' and 'OtherCost'. In addtion, could you please provide table structures of your report?

Regards,

Jimmy Tao

[ridho72]

Hi Jimmy!

This is my relationship table. It linked by SKU Name. Please advice.