Hello,
Is it possible to reference calculated member (aggregation)? My problem is that I need to check for several values in my condition:
CASE WHEN [Client].Currentmember.Name = "Client A" OR [Client].Currentmember.Name = "Client B"
THEN 1
END
My Client field/dimension alredy have Computed member which aggregates them (I am using it for sorting). It have following code:
Aggregate({[Client].[Client A],
[Client].[Client B]}
)
I would like to use this aggregation not just to simplify code but also for easier maintenance as scope of those clients might be changed in future and I would like to update it only in 1 place - my calculated member and not in other measurements. So I have tried code like this:
CASE WHEN [Client].Currentmember.Name = [Client].[Aggregated Clients]
THEN 1
END
But it does not work, complaining about wrong data type (number, instead of text). Could you please help me?
Thanks in advance!