Error free DAX formula can't be added to Excel PivotTable

Question

Another issue from the consumate PowerPivot newbie;

I add the following DAX measure:

DirectOnlineSales:=CALCULATE(Sum('Query'[SaleAmount]),'Query'[SaleType] = "Direct-Online")

Adding this both in PowerPivot, and Excel (separately as different tests) not only generates no error, but also displays a number next to the measure in PowerPivot.

But when I try to add the measure to my PivotTable, I get:

"Could not add the field "DirectOnlineSales" to the PivotTable because the formula is invalid."

Am I doing something wrong here?

Answer 1

Hi,

Please try the steps in this link http://www.powerpivotpro.com/2010/08/two-common-powerpivot-error-messages/ and also see this http://powerpivot-info.com/post/411-changing-how-powerpivot-handles-dax-errors 

---

Challen Fu

TechNet Community Support