Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |