round total for decimal numbers

[zhandos]

Hello,

In table visual column a total for SUM aggregation returns 32.83 with 2 decimal points, although customer expects 32.85. If i round to three decimal points, then it is ok. Conection type: direct

[amitchandak · Accepted solution]

@zhandos , if you are getting 2 decimal places from the source then you have lost the information. (means you have query or view that rounded it off to 2 decimal place)

In power bi, make sure you are not rounding off in formula like

sumx(Table, round(Table[Value],2))

Then it should work fine. Check measure or column tools and you can change decimal place to 3