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.

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

nickchobotar

 

1. Yes we're using the same everything as all the necessary files including the pbix file has just been sent in an email to me and I've changed the file paths as necessary.

2. We're dividing by a column, not a measure. On occassion, these columns are made using other columns we've also created

 

Another note which may or may not be of importance. Looking at just the Transactions or the Checkout numbers alone, they're correct for both of us. But only when my coworker divides them does he get an incorrect answer while I get the correct one. Formula: Conversion % = sum('Data1'[Transactions])/SUM('Data1'[Carts]) 

The answer he gets is 70000% while I get 46%. Odd huh? This is exact formula I copy and pasted on my computer to get the correct answer.

 

Cheers guys

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

    I believe so since I'm using my coworkers pbix file. Would those column data types change if they're opened on a new machine?

    I'll give that a go when we have the chance and get back to you.

    Thanks for the suggestion, that had not even come into my mind

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

      HanLee

       

      You have a very unusual situation and I cannot tame my curiousity.  Were you able to find a solution? 

       

      N -

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

        Hi nickchobotar

         

        Nop, we tried uninstalling and reinstalling but that didn't work. Currently we haven't tried using the divide function as mentioned earlier as my coworker has been quite busy but hopefully that works out for us.

         

        If anyone else has any suggestions please do comment below.

         

        Cheers

  • 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.