Forum Discussion

HanLee's avatar
HanLee
Icon for Helper I rankHelper I
8 years ago
Solved

Incorrect Measure Result when dividing on one system

Hi folks,   My colleague is having a bit of trouble with power bi when divinding using a measure. This occurs when we creat a new column within Power BI and use that to divide or divide by.   I'v...
Need Help
  • HanLee's avatar
    HanLee
    8 years ago

    Hello everyone! We've found a solution using Quick Measures which is a preview feature at the moment.

    A little more time consuming but at least produces the correct answer.

nickchobotar's avatar
nickchobotar
Icon for Skilled Sharer rankSkilled Sharer
8 years ago

HanLee

I see!
On your co-worker's machine, are the columns' data type set to the same values as on yours ?

 

What happens if you use a  DIVIDE() function?   DIVIDE(SUM('Data1'[Transactions]), SUM('Data1'[Carts]))

 

Thanks, N -

HanLee's avatar
HanLee
Icon for Helper I rankHelper I
8 years ago

nickchobotar

 

My coworker tried the divide function rather than using / and it was ineffective :(

We're running out of solutions and I'm not sure what to do. 

I'm beginning to think that this is a problem with his computer rather than the program but I'm not sure why this would occur and what would cause it.

  • HanLee's avatar
    HanLee
    Icon for Helper I rankHelper I
    8 years ago

    Hello everyone! We've found a solution using Quick Measures which is a preview feature at the moment.

    A little more time consuming but at least produces the correct answer.