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.
