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] ) )
Hello Ben9987
Can you please try the below measures
Total = Sumx ( YourTable, IF(ISBLANK(Measure A),Measure B,Measure A) )and use this measure in table visual..
If this is not working, requesting you to provide your pbix file with dummy data..
Hope it will help you.
Regards
sanalytics
If it is your solution then please like and accept it as solution