Same totals for different columns

[Anonymous]

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!

[Greg_Deckler · Accepted solution]

@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

[Anonymous · Accepted solution]

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.

[Greg_Deckler · Accepted solution]

@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