Forum Discussion
Matrix Column Subtotal showing incorrect values
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.
3 Replies
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
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.
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.
