Forum Discussion

OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago
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. ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Try this measure

    OPEX_ = SUMX(VALUES(Product_Group[Product_name]),[Per_Unit (main)]*[Deal#count]*-1)

    Hope this helps.

OSS's avatar
OSS
Icon for Helper III rankHelper III
7 years ago

Dear Ashish_Mathur 

I have checked, you are right. It seems there is something wrong with my upload file. Actually the file I uploaded contains different amount. It seems I need to review upload file.

 

Thank you very much for your priceless help and patience. 

 

Best Regards

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

You are welcome.  If my reply helped, please mark it as Answer.