SQRT Function returning Error

[Anonymous]

Hi Folks,

I have an issue in Dax funtion SQRT.

This is the error it is returning.

The measure we hade is supposed return the square root of product of 2 measure values.
Measure = SQRT([Part1] * [PART2])

This error is happening for the below mentioned values 

Examples.

Measure = SQRT(1065016356*63025475556)

Measure = SQRT(1467284654*98905757874)

Please help me in solving this issue 

Thanks 
Mahesh R

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ,

Please update the formula of Measure as below and check whether you can get the expected result:

Measure = SQRT ( ABS ( [Part1] * [PART2] ) )

SQRT problem in DAX/excel - too many decimal places?

Handling Errors in DAX Expressions

Best Regards

[watkinnc]

Those are big numbers. Perhaps:

Measure = CALCULATE(SQRT([Start1]*[START2]), [Start1] >0)

--Nate