Forum Discussion
OSS
Helper III
Helper IIISum 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.
10 Replies
OSSActually 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.
- Ashish_Mathur
Super User
Hi,
Try this measure
OPEX_ = SUMX(VALUES(Product_Group[Product_name]),[Per_Unit (main)]*[Deal#count]*-1)
Hope this helps.
- OSS
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.