Forum Discussion
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 🙂
/Andreas
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.
3 Replies
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.
Hi au564589 ,
How about the result after you follow the suggestions mentioned in my original post?
Could you please provide more details or expected result about it If it doesn't meet your requirement?
If you've fixed the issue on your own please kindly share your solution. If the above posts help, please kindly mark it as a solution to help others find it more quickly.
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.
Hi au564589 ,
I am not sure as you haven't shared any screenshots of error or your measures.
Try checking the values in the columns that are used in DIVIDE function.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Thanks,
Pragati
