Forum Discussion

Vallirajap's avatar
Vallirajap
Resolver III
2 years ago
Solved

Hii all

I face one type of scenario newly.  I have two measures.  1. [measure1], It returns a value in minus (-254). This measure 1 has the addition of two more measures.             For example: Measure1...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Vallirajap 

     

    1.45E-13 (scientific notation) is equivalent to 0.000000000000145 in decimal form. It is every close to zero. This happens as when doing the calculation, it may actually be calculated with the decimal numbers, so the result will have some small decimal places. To deal with it, we can give the result a specific number of digits after the decimal point. For example, if you want the result to be a whole number, you can use ROUND function 

    New = ROUND([measure1] + [measure2], 0)

    ROUND function (DAX) - DAX | Microsoft Learn

     

    Best Regards,
    Jing
    If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!