DAX ERROR :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? 



    • Edited by Steve_Fox Monday, December 12, 2011 11:16 AM
    Monday, December 12, 2011 11:07 AM