Forum Discussion

powerbirino3's avatar
powerbirino3
Frequent Visitor
9 years ago
Solved

Calculated column incorrect calculation

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 BI10'11

 

I'm literally... WTF :smileyfrustrated:

 

Thanks for any help

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

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

    • powerbirino3's avatar
      powerbirino3
      Frequent Visitor
      9 years ago

      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's avatar
        Anonymous
        Not applicable
        9 years ago

        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.