Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello there,
I hope that somebody can help me. I have the dreaded “Chart data contains not a number (NaN) values.”, message and I don’t think that I am dividing by Zero. Here is my DAX Code:
Inventory = SUMX(SUMMARIZE('mvdt V_PSI_DailyInventory',[GCAS_Code],[Inventory_Date],"Inventory Qty", if(FIRSTNONBLANK(BUOM[BUOM],1)="CS",AVERAGE([Cases_Inv]),if(FIRSTNONBLANK(BUOM[BUOM],1)="IT",average([Cases_Inv])*AVERAGE([ItemPerCase]),average([Cases_Inv]) * AVERAGE([SU_Factor])))),[Inventory Qty])
Is there a quick fix for this J
Hi @Anonymous,
Could you please check whether all your columns are in number format? Kindly share your pbix to me to have a check if possbile.
Regards,
Frank
Hi @Anonymous,
Has your issue been solved? If any other question, feel free to let me know please.
Regards,
Frank
Thank you for your reply. I wasn't able to fix this issue yet.
From the above DAX code I looked at each column and found the following data:
[GCAS_Code] = Only Numbers (e.g. 82845734)
[Inventory_Date] = Only Numbers (e.g 12/6/2018)
* [Cases_Inv] = Contains '0' or 'NaN' values
[BUOM] = Contains (Blank) or 'CS' text values
[ItemPerCase] = Contains (Blank) or Number values
[SU_Factor] = Contaions Number values
[Inventory Qty] = Contains Number values
The Cases_Inv Column acutally has 'Nan' writen in it, which might be causing the problem.
Thje Cases_Inv is a calcualted column and the DAX is as follows:
Cases_Inv = if([BUoM]="CS",[Inventory_Qty],[Inventory_Qty]/[ItemPerCase])
Do you think I could change anything in the above, so I don't get the 'NaN' result?
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |