EXISTS function returns first values only

Question

Can someone please help me out understand what am I doing wrong? I have the following structure of my CUBE:

And I`m creating the following calculated member in MDX in Visual Studio:

CREATE MEMBER CURRENTCUBE.[Measures].[Current_State]

AS EXISTS([DWH Dim Work Item Current].[State].[State].Members,[DWH Dim Work Item Current].[Title].Currentmember).Item(0).Name,

VISIBLE = 1;

But for some reason I get only the first value (i.e. "Active") for every row in Excel:

Can someone please tell me what I`m doing wrong and how I should fix it?

Thank you in advance!

Answer 1

Does EXISTING work any better?

CREATE MEMBER CURRENTCUBE.[Measures].[Current_State]

  AS EXISTING([DWH Dim Work Item Current].[State].[State].MEMBERS).ITEM(0).NAME,

VISIBLE = 1;