Matrix Column Subtotal showing incorrect values

[GofretPowerBi]

Hello everyone, I am getting the wrong values in subtotals in power bi. I tried various solutions that I saw on the forum but the result did not change. Stock cogs formula invoice qty * avg suc . Invoice qty and stock unit cost are linked via date and main material list. It gives correct results when looking at the goods one by one, but it gives wrong results in column total and row total, and the difference is too much. How can I fix this problem? Thank you.

[GofretPowerBi]

Coming from the Qty direct sales report it's not a calculated measure. Average of unit prices from stock in avg. I'm new to Power bi, I would appreciate it if you could explain the solution in a little more detail.

[amitchandak]

@GofretPowerBi , if those are two measures then you need to have a like with all row columns  

Sumx(summarize(Table, Table[Row COlumn1], Table[Row Column2], "_1", [qty] * [avg]), [_1])

you can use fact  as a table and dim column in columns of summarize

[GofretPowerBi]

Coming from the Qty direct sales report it's not a calculated measure. Average of unit prices from stock in avg. I'm new to Power bi, I would appreciate it if you could explain the solution in a little more detail.