Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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!
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!
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
96 | |
94 | |
82 | |
70 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |