Forum Discussion
Post PartisanChart Contains NAN
Hello all - Any ideas why i get this warning on the following visual?
Hi NewbieJono ,
NaN (not a number) will be shown in following conditions. You can check whether they exist in your measures.
0 / BLANK () = NaN
0 / 0 = NaN
Infinity / Infinity = NaN (e.g. (10 / 0) / (7 / 0))
For troubleshooting, you can create another measure ISERROR() function to check which value is NaN value. For example, if ISERROR(SUM(Table[column])) returns "True", it means SUM(Table[column]) returns an error(e.g. NaN value).
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
- parry2k
Super User
NewbieJono where you are seeing this warning?
NewbieJono
Hi NewbieJono ,
NaN (not a number) will be shown in following conditions. You can check whether they exist in your measures.
0 / BLANK () = NaN
0 / 0 = NaN
Infinity / Infinity = NaN (e.g. (10 / 0) / (7 / 0))
For troubleshooting, you can create another measure ISERROR() function to check which value is NaN value. For example, if ISERROR(SUM(Table[column])) returns "True", it means SUM(Table[column]) returns an error(e.g. NaN value).
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
