Forum Discussion
Error in Measure
Hi All, Any help with the below issue? I have created a measure but somehow instead of 0 it is showing me wrong value for a particular day ( Rest days are correct ) Regards
Hello Anonymous ,
check this solution https://community.fabric.microsoft.com/t5/Desktop/Remove-Scientific-notation-in-measure/m-p/652986
not sure what the issue is, changing the data type to currency and showing only 2 decimals is making it look fine but my rest of the values are still showing wring like below.
Not sure how this abrupt number is coming as a %
Anonymous , this is a scientific equation because the number is huge.
This is wrong as it should simplygive 0 as the result, you can see here its simply dividing 2.03 wih 0 and that should throwan error but I have used 0 as an alternative result in my measure so I'm not sure how this number is coming up.