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?
Please try the steps in this link
http://www.powerpivotpro.com/2010/08/two-common-powerpivot-error-messages/ and also see this
TechNet Community Support