Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Chart data contains not a number (NaN) values

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

Need Help

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    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's avatar
      v-frfei-msft
      Icon for Community Support rankCommunity Support
      8 years ago

      Hi Anonymous,

       

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

       

      Regards,

      Frank

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        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?