Error in Measure

Question

Hi All,&nbsp;Any help with the below issue?&nbsp;I have created a measure but somehow instead of 0 it is showing me wrong value for a particular day ( Rest days are correct )&nbsp;Regards

idrissshatila · Answer

Hello&nbsp;Anonymous&nbsp;,
&nbsp;
check this solution&nbsp;https://community.fabric.microsoft.com/t5/Desktop/Remove-Scientific-notation-in-measure/m-p/652986
&nbsp;

anonymous · Answer

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 · Answer

Anonymous&nbsp;, this is a scientific equation because the number is huge.

anonymous · Answer

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.

uzi2019 · Answer

hi&nbsp;Anonymous&nbsp;You try using custom format. please refer the link below.https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings&nbsp;If my post helps give kudos and accept it as a solution!Thanks

Forum Discussion

Error in Measure

5 Replies

Related content

Error: The model doesn't have a measure named Measure on table

Measures Creating Error

error message

Error in Measure?

Measure