Error in Measure

Anonymous · ‎10-25-2023

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 · ‎10-26-2023

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

Don't forget to give thumbs up and accept this as a solution if it helped you!!!

Idrissshatila · ‎10-25-2023

Hello @Anonymous ,

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos

Follow me on LinkedIn

Vote for my Community Mobile App Idea

Proud to be a Super User!

Anonymous · ‎10-26-2023

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 · ‎10-26-2023

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos

Follow me on LinkedIn

Vote for my Community Mobile App Idea

Proud to be a Super User!

Anonymous · ‎10-26-2023

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.