Error in Measure

[Anonymous]

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

[Uzi2019]

hi @Anonymous 

You try using custom format. please refer the link below.

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

If my post helps give kudos and accept it as a solution!
Thanks

[Idrissshatila]

Hello @Anonymous ,

check this solution https://community.fabric.microsoft.com/t5/Desktop/Remove-Scientific-notation-in-measure/m-p/652986

[Anonymous]

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 %

[Idrissshatila]

@Anonymous , this is a scientific equation because the number is huge.

[Anonymous]

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.