Calculate the column Sum with SUMX values

[Anonymous]

Hello

I create this table visual with the Measure above the table.

As you can see, the sum per year is not calculate the correct value. For example sum of column 2022 have to be 27,000.

What did I wrong?  Can u help me with the correct measure?

Thank you in advance.

Maha

[Greg_Deckler]

@Anonymous 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]

Hi Greg, unfortunately I am not experienced enough in PBI Dax to understand what you are trying to explain to me.
I have tried to create a measure with HASONEFILTER/ HASONVALUE but still have the wrong column total.