Forum Discussion

au564589's avatar
au564589
New Member
5 years ago
Solved

NaN Errors

Hi,   Can NaN-values/errors occur for other reasons than dividing by 0? In my case, it get NaN erros in my measures eventhough i'm using the divide funciton?   Hope you guys can help me 🙂 /Andr...
Need Help
  • v-zhenbw-msft's avatar
    v-zhenbw-msft
    5 years ago

    Hi au564589 ,

     

    If your denominator is 0 and you use “/”, there will be NaN.

     

     

    If you don’t want to show the NaN, you can use the DIVIDE function, and configure the third parameter.

     

     

    Or maybe you can refer the following thread, hope they help.

    https://community.powerbi.com/t5/Desktop/NaN-Error/m-p/118804

    https://community.powerbi.com/t5/Desktop/Hiding-Blank-Infinity-NaN-Error/m-p/1264561

     

    If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data?

    It will be helpful if you can show us the exact expected result based on the tables.

     

    Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.

     

    Best regards,

     

    Community Support Team _ zhenbw

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

     

    BTW, pbix as attached.