Forum Discussion
Solved
Sum problem in matrix table
Dear All I have trouble with the matrix table. In this table sum of rows are ok, even total grand also correct. However Total sum for each column is wrong. Please help me to solve this problem. ...
Hi,
Try this measure
OPEX_ = SUMX(VALUES(Product_Group[Product_name]),[Per_Unit (main)]*[Deal#count]*-1)
Hope this helps.
Actually amounts in my table are result of calculations. In order to give more clear picture of my question I would like to add model itself.
Hi,
Try this measure
OPEX_ = SUMX(VALUES(Product_Group[Product_name]),[Per_Unit (main)]*[Deal#count]*-1)
Hope this helps.
Dear Ashish_Mathur
Thank you very much for your reply. Actually your formula works for my table. Total sum for columns are right.
But my total Opex amount is changed.
You are welcome. I just checked - no numbers in the matrix have changed. Please recheck.