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.

BILASolution's avatar
BILASolution
Icon for Solution Specialist rankSolution Specialist
8 years ago

Hi, Put on diferent card visuals SUM('Data1'[Transactions]) and SUM('Data1'[Carts]) and then make a comparison of the results  between your computer and your co-worker one. If the values are different, the data could be the problem.

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

BILASolution 

 

The sum of transactions and carts are correct. We've checked that but the error occurs ONLY when dividing