Chart data contains not a number (NaN) values

[Anonymous]

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

[v-frfei-msft]

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

[v-frfei-msft]

Hi @Anonymous,

Has your issue been solved? If any other question, feel free to let me know please.

Regards,

Frank

[Anonymous]

@v-frfei-msft,

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?