Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

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

     

     

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

     

     

KNP's avatar
KNP
Super User
3 years ago

Yep, except I think something is going on with the data because the measure is simple.

 

Anonymous - post data, PBIX and even code from advanced editor could help. Hide any sensitive info. Something is going on in the data/calculations for you to think it is incorrect. We can't answer without further info.

 

 

  • KNP's avatar
    KNP
    Super User
    3 years ago

    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.