locked
Error Message -The value for 'SMS Charges' cannot be determined. Either 'SMS Charges' doesn't exist, or there is no current row for a column named 'SMS Charges'. RRS feed

  • Question

  • Hi Folks 

    I am getting the error message outlined above when I try to divide one column by another in a DAX formula. Th forumula is =[SMS Charges]/[SMS Count]). See this link for view of table that includes these two columns 

    I have found any explanation of on this occurance in the document "Data Analysis Expressions (DAX) In PowerPivot for Excel 2010" from the  powerpivotfaq.com.. but can't see a fix.

    Can any one suggest a fix? 

    Thanks 

    Steve 

    Monday, December 12, 2011 2:53 PM

Answers

  • Hi Steve

    If you are doing this as a calculated column, try using the formula below:

    =IF(ISERROR([SMS Charges]/[SMS Count]),1)


    Sometimes the entire column errors out if the calculation cannot be performed due to bad data in a specific row.  With the expression above, you can then filter the rows with value 1 and more closely examine the expected values [SMS Charges] and [SMS Count] which can more easily help you uncover if bad data was loaded




    Javier Guillen
    http://javierguillen.wordpress.com/
    • Marked as answer by Challen Fu Monday, December 19, 2011 9:51 AM
    Tuesday, December 13, 2011 8:34 PM
    Answerer