Wrong totals when calculating percentages

[FloKlupp]

Hello,

can you help me with the following problem:

I uploaded percentages (decimal values) in Power BI as a column of a table and worked with them by using a measure.

So far everything works, except the total in the result table. The totals are unfortunately calculated incorrectly, because of the calculation logic and the relationships of the tables and measures. However, the totals are of great importance for my further analyses. Do any of you have any idea how to change the computational logic of Power BI of what to consider in my measure and formulas?

Here’s our example:

The calculation-logic for the total is wrong, because i need the sum of the column

-> 4.175 +29.847,55 + 5.010,60 = 39.033,15

and NOT 12.215.782,26 * 0,0255 = 311.502,45 !

What to do there?

Thank you in advance!

Best regards,

Florian

[Greg_Deckler]

@FloKlupp 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

You might also be able to use the Show as percentage option with the source column instead of a measure, or with a measure that doesn't first calculate the percentage.