Forum Discussion

nickuhlenhuth's avatar
nickuhlenhuth
New Member
7 years ago
Solved

undefined

The DIVIDE function doesn't work in PowerBI. It is multiplying results by 3.

  • Resolved now.

     

    The issue was that I was creating a Column using DIVIDE between two aggregated columns that had 3 rows.

    Once I changed to use DIVIDE within a Measure, it worked as expected.

2 Replies

  • Are you saying that DIVIDE( exp1, exp2 )  produces a different result to exp1 / exp2 ? This does not sound right. Can you post a screenshot with a table showing the denominator, numerator and the result of the divide function?

    • nickuhlenhuth's avatar
      nickuhlenhuth
      New Member

      Resolved now.

       

      The issue was that I was creating a Column using DIVIDE between two aggregated columns that had 3 rows.

      Once I changed to use DIVIDE within a Measure, it worked as expected.