Hi!

I am using the following MDX to summarize the members of a calculated measure at the total level.

Example:
Time Call
A1 1 * 2 = 1
A2 1 * 3 = 3
A3 1 * 2 = 2
Total = 1 + 3 + 2 = 6

The problem is that when filtering to A1 and A2, it still shows 6 as the total. How could I update the MDX to make it update the total to 4 when filtering A1 and A2. Thanks!

MDX:

CREATE MEMBER CURRENTCUBE.[MEASURES].[AcdTimexAcdCall]
AS [Measures].[Call]*[Measures].[Time],
VISIBLE = 1;

CREATE MEMBER CURRENTCUBE.[MEASURES].[TotalAcdTimexAcdCall]
AS [MEASURES].[AcdTimexAcdCall],
VISIBLE = 1;
Scope ([Dim Agent].[Agent Name].[All], [MEASURES].[AcdTimexAcdCall]);
This = sum([Dim Agent].[Agent Name].[All].Children);
End Scope;