topic Re: Matrix Visual with Incorrect Total in DAX Commands and Tips

Matrix Visual with Incorrect Total

juhoneyighot — Thu, 18 Jul 2024 17:48:17 GMT

Hi All,

I have a problem with my matrix visual It is showing an incorrect Rev Recog subtotal for _Current PM Contact

Formula for Rev Recog=[% Comp] * SUM('salesorderdetail'[Amount])

For the total of Rev Recog with Benton Graves as _Contact PM Contact this should be 7,809,514.68.

Anyone who has an idea how I get through this?

Thank you.

Greg_Deckler — Thu, 18 Jul 2024 17:58:07 GMT

Anonymous — Tue, 06 Aug 2024 06:44:21 GMT

Can you provide relevant example data, if you have relevant example data, it will better help you to solve the problem.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.