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.

     

     

katika555's avatar
katika555
Resolver I
3 years ago

If our dataset is like this picture, you dont need any Values just Divide, or share your file.

KNP's avatar
KNP
Super User
3 years ago

Yeah, but Anonymous is trying to add a measure, not a column.

 

  • katika555's avatar
    katika555
    Resolver I
    3 years ago

    Same with measure 🙂

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