I have the following se

Y,K,M,Q,T,G,

I want to use MDX to return the name of the members parent for the first value in the set <=0 zer
for example for the following dat

Y 15
K 12
M 10
Q 9
T 7
G
W

the answer would be 'T

I have this logic in sql as a large nested if statement that basicly walks the set Y-W checking for <=0 and returns the previous value
--T SQL Cod
IF (@Yavl<=0
BEGI
SET @Class='Y
EN
ELSE IF (@Kavl<=0
BEGI
SET @Class='Y
EN
ELSE IF (@Mavl<=0
BEGI
SET @Class='K
EN
ELSE IF (@Qavl<=0
BEGI
SET @Class='M
EN
ELSE IF (@Tavl<=0
BEGI
SET @Class='Q
EN
ELSE IF (@Gavl<=0
BEGI
SET @Class='T
EN
ELSE IF (@Wavl<=0
BEGI
SET @Class='G
EN
ELS
BEGI
SET @Class='W
EN

Is there a more elegant manner to do this in MDX?

ok I have worked out an MDX method for doing this
IIF([Measures].[Yavl]<=0,[cls].[All cls].[Y].Name
IIF([Measures].[Kavl]<=0,[cls].[All cls].[Y].Name
IIF([Measures].[Mavl]<=0,[cls].[All cls].[K].Name
IIF([Measures].[Qavl]<=0,[cls].[All cls].[M].Name
IIF([Measures].[Tavl]<=0,[cls].[All cls].[Q].Name
IIF([Measures].[Gavl]<=0,[cls].[All cls].[T].Name
IIF([Measures].[Wavl]<=0,[cls].[All cls].[G].Name,[cls].[All cls].[W].Name