I have a calculated measure that shows up as #VALUE! in
Excel (XP) Pivot when it is the only measure on the data
items pane. When I add another measure (pivot table must
have at least one dimension to be able to observe this),
correct value shows up. What could have caused this?

The MDX expression used was:

(StrToSet("Axis(1)").Item(0).Item
(0).Dimension.CurrentMember, [Measures].[Measure Name]) /
(StrToSet("Axis(1)").Item(0).Item(0), [Measures].[Measure
Name])

TIA,

Jenny