Calculated column incorrect calculation

[powerbirino3]

Hi guys,

I'm facing a problem which I've never seen using Power BI and I have no idea why.

The problem is that I have created a calculated column with a basic calculation like this: "Euros / Weight / Quantity" and results have no completly sense.

What I firstly 've done, is to create a calculated table using group by and addcolumns DAX functions, once I've had the desired format, I've added a calculated column called Quantity to the calculated table, and last step, I've added a calculated column called €/Kg (last column of the image).

Where is the problem? €/Kg column is wrong! Look at the results in the image

For example, first row of the image:

1668,85 (EUROS) / 6600 (WEIGHT) / 0'03 (QUANTITY)

CALCULATOR	8'42
Result in Power BI	10'11

I'm literally... WTF

Thanks for any help

[Anonymous]

Is Quantity a rounded figure?  For example is the real figure on the first line 0.025 but its displaying as 0.03?

[powerbirino3]

It's rounded to two decimals, yes, but in this case, "original" number is 0.03.

In my knowledge, this shouldn't affect, just decimals, right?

[Anonymous · Accepted solution]

Working with decimals can be funny in places. Sometimes a number will display as rounded but systems will often keep the "true" figure.  An easy test might be to update your formula to something like

Round(Euros, 2) / Round(Weight, 2) / Round(Quantity, 2)

See if that changes the output any.

[powerbirino3]

That did the trick.

Thanks