Forum Discussion
Sum problem in matrix table
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.
Dear Ashish_Mathur
When remove all filters OPEX amount is equal to 76.466.791 (with the formula [Per_Unit (main)]*[Deal#count]*-1)
After changing formula with the SUMX(VALUES(Product_Group[Product_name]),[Per_Unit (main)]*[Deal#count]*-1)
total OPEX amount equals 73.911.984
for checking please remove product group and segment filters.
Best Regards