Forum Discussion
Same totals for different columns
Hi, how can I correct wrong totals, which are shown the same here? I want to have different totals per column.
Please don't give me links to very long and hard to understand articles. Thank you!
Anonymous Not really enough information to know what is going wrong but standard answer is this and it's not really that long or complex. But, looks like in your total row the Iva_V value is 0 so it's just going to be the SUM of your coe05 column times 1.
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- Anonymous2 years ago
Hi Anonymous ,
Greg_Deckler Thanks for your concern about this case!
Anonymous Have you solved your problem? If not, generally speaking, errors in Total in matrices or tables are due to contextual reasons. The general solution is:Measure = SUMX(VALUES('YourTable'[Row Header Column]), [Columns for which total needs to be calculated])Then put this measure into the table or matrix instead of the original column.
I once replied to a post about Total in the matrix, maybe it will be helpful to you:
Solved: Totals in Matrix - Microsoft Fabric Community
If this does not solve your problem, please provide your sample data and a screenshot of the problem.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- Greg_Deckler
Community Champion
Anonymous Not really enough information to know what is going wrong but standard answer is this and it's not really that long or complex. But, looks like in your total row the Iva_V value is 0 so it's just going to be the SUM of your coe05 column times 1.
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 - AnonymousNot applicable
Hi Anonymous ,
Greg_Deckler Thanks for your concern about this case!
Anonymous Have you solved your problem? If not, generally speaking, errors in Total in matrices or tables are due to contextual reasons. The general solution is:Measure = SUMX(VALUES('YourTable'[Row Header Column]), [Columns for which total needs to be calculated])Then put this measure into the table or matrix instead of the original column.
I once replied to a post about Total in the matrix, maybe it will be helpful to you:
Solved: Totals in Matrix - Microsoft Fabric Community
If this does not solve your problem, please provide your sample data and a screenshot of the problem.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.