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.
Hi HanLee,
What exactly is incorrect about it like: is the format incorrect, does it give the wrong result etc ?
Regards,
L. Meijdam
HanLeeHi 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?
- nickchobotar
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
