Forum Discussion
rafaelr08
3 years agoNew Member
The Sum is Incorrect
Power Bi is summing the values incorrectly. The values should be equal to zero but its showing a balance of 0.000000000000185 instead of zero as seen in the images below. and now sho...
Anonymous
3 years agoNot applicable
Hi rafaelr08 ,
If you choose the Sum in Values, the value of the total is to add up all the values above you. If the above rows add up to 0, then the total returns 0.
If you choose for Min or Max, the totals will return the smallest or largest values of all the rows above instead of adding them up.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.