sum column error

[nix]

 

In 1st one steaming col the row value giving right but when i am using sum(steaming col) eaither by formula sum direct  or by creating a measure0 it is giving the 2nd pic's value which is not at all correct and higer then actual,why is it so

[nix]

I did it already but not working

[nix]

Already done like this

[Kishore_KVN]

Hello @nix ,

Please check the steaming column datatype and make it decimal number. 

Once the values are fixed use SUMX for the measure instead of SUM as it is a Row Level Calculation. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!