Handling very small numbers

Hi user1462 ,

Based on your description, I have created a simple sample:

Please try:

Measure = 
var _a = FORMAT(SUMX('Table',[Column1]),"Scientific")
var _b = FIND("-",_a)
var _c = VALUE(RIGHT(_a,LEN(_a)-_b))
var _d = FORMAT(SUMX('Table',[Column1]),"General Number")
return RIGHT(_d,LEN(_d)-_c-1)

Final output:

Note: the final output is not a number , it is text type, if you want number type, you need to use value() function.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.