I have a cube with a Measure (A) and a dimension (C). I've created a Calculated Measure (B) whose tuple is Measure A with the all member of Dimension C. The Calculated Measure looks like this:
When I place the dimension on a pivot table, the Calculated Measure B reflects the correct value, Measure A by all members of dimension C.
When I place the dimension in the filter area and filter by one or more members, the Calculated Measure B reflects the correct value, Measure A by all members of dimension C. The same answer as Scenario 1.
When I place the dimension in the pivot table AND filter by one or more members, I am getting a different answer than I want. It is filtering first by the members selected and then reflecting the Calculated Measure as the All value of ONLY the selected
filter members. I want the calculated Measure to reflect Measure A by all members of dimension C. (The same number as in the first two scenarios)
Is there any way to create the Calculated Measure differently so that all three scenarios give me the same answer?
View Complete Post