Forum Discussion
Helper IIncorrect Measure Result when dividing on one system
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.
Helper IHi there, thanks for your reply. It's just an incorrect answer. Sometimes we divide a small number by a larger one and we get a massive overblown result like 6000 when the answer should be .30.
Copying and pasting the formula my coworker used into my own measure on my computer works fine though. Any ideas?
Skilled Sharer
Could you please clarify this:
1) Are you both using the same dimensional model?
2) Are you dividing by actutal numbers or measure?
Please post the code here.
N -
- HanLee
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
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
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