Calculation in table visualization

[matheus_arruda]

Dear,
my table is doing a very wrong calculation because it says 42.33 + 51.17 is equal to 189.20, though the correct value would be 93.50.
How can I fix this problem?

The formula in my calculated column that generates this value is:

Perda Rougher = SUM('CADASTRO PERDA'[Perda Rougher])*[Peso Rougher Calculado]/100

Print Screen

[matheus_arruda · Accepted solution]

Hello peoples, I discovered that the calculation function was wrong, thank you all!
I'm change de SUM function for SUMX and solved my problem!

[v-yuezhe-msft]

@matheus_arruda,

Do all the fields in the above table visual come from a single table? If not, could you please share dummy data of your original tables and tell us the relationship between the tables so that we can test?

Regards,
Lydia

[vijay_kolisetty]

Hi

As I dont have enough info, I can guess to use the below and let me know if any concerns

Perda Rougher = SUM('CADASTRO PERDA'[Perda Rougher])*SUM([Peso Rougher Calculado])/100

and provide the value of 'CADASTRO PERDA'[Perda Rougher]). Otherwise change the name of the calculation and try once as it may dependent of the other rollup with the same name.

Regards,

V