Matrix Visual with Incorrect Subtotal

[juhoneyighot]

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=Est Rev*%Comp

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 · Accepted solution]

@juhoneyighot First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8

[v-tangjie-msft · Accepted solution]

Hi @juhoneyighot ,

Thanks @Greg_Deckler  for the quick reply and solution. Allow me to offer some additional insights:

You can create another measure [New Rev Recog] to place on the visual object instead of the original measure [Rev Recog].

New Rev Recog = SUMX(VALUES('Table'[Name]),[Rev Recog])

If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

Best Regards,

Neeko Tang

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

[Greg_Deckler · Accepted solution]

@juhoneyighot First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8