Forum Discussion
Getting Wrong Grand Total
- 2 years ago
Hi Ben9987
First please vote for this idea by Greg_Deckler"
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"
In order to force additivity over your measure you need to aggregate the values using SUMX by iterating the distinct visible values of the column (or column combinations) that represents the core structure of your Table or Matrix visual.
MeasureA Correct Total = SUMX ( DISTINCT ( 'Table'[Country] ), COALESCE ( [MeasureA], [MeasureB] ) )
Hi Ben9987 ,
Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information and description to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng