Forum Discussion
DAX formula calculation gives wrong value!?
Hello, I run into a dilemma with a calculation in DAX that works fine for one column and gives wrong results if applied to a different column. I have this data set , where STC, STCR, LTC and LTCR a...
Hi Anonymous ,
There seems nothing error with the measure.
LTCR = DIVIDE([FirstValue] - MIN('Piping UT ex'[Tmin (mm)]), [LTC])We can calculate the ([FirstValue] - MIN('Piping UT ex'[Tmin (mm)]) first.
This part calculates well.
Let me check the measure [LTC].
LTC = ([FirstValue] - [LastValue]) * 1.33First LTC result is (12.9-12.54)=0.36. 0.36*1.33=0.4788.
Then 9.5/0.4788=19.84.
If you want the reslut 19.84 change to be 19.79. Please try to change the measure [LTC].
LTC = var _1= ([FirstValue] - [LastValue]) * 1.33 return ROUND(_1,2)Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The calculation is correct, your LTC for the top value in the example is 0.4788 not 0.48. (add decimal places to your measure to verify)
If you manually do the calculation with that value, you'll see it is right.