Wrong total sum of measure

[Ameri]

Hi All, 

I need your help regarding Power BI.

I have 2 tables as below. (COST / SALES)

* 1 Measure  = sum([COST[unit cost])

* 2 Measure = [1 Measure]*SALES[sales_quantity]

An error of  2 Measure sum occurs. So I add more measure.

* 3 Measure = IF(HASONEVALUE('COST'[product_code]), [2 Measure],

                            SUMX(VALUES('COST'[product_code]), [2 Measure]))

Thanks to 3 Measure, I can calculate the cost of goods sold per buyer each month.

The value I get for each month is right, but the total sum of the numbers don't match.

How can I get the corresponding value?

[v-shex-msft · Accepted solution]

HI @Ameri ,

It seems like a common measure total level calculation issue, please take a look at following link to know more about how to avoid this:

Measure Totals, The Final Word

Regards,

Xiaoxin Sheng