Else Statement isn't working in Dax.

[Anonymous]

Hi,

I'm trying to run a dax statement ----->>

Measure 5 =
VAR SelectedState =
CALCULATE (
[Measure 3],
INTERSECT (
VALUES ( Qualifiers[State] ),
VALUES ('Table 6'[State])
)
) VAR UnSelectedState =
CALCULATE (
[DSA_FallOut],
EXCEPT (
ALLSELECTED(Qualifiers[State] ),
VALUES ( Qualifiers[State] )
)
) VAR AllState =
CALCULATE (
[DSA_FallOut]*1,
ALL(Qualifiers[State]) )
RETURN
IF (
HASONEVALUE( Qualifiers[State] ),
SWITCH(
VALUES(Qualifiers[State]),SELECTEDVALUE(Qualifiers[State]),
SelectedState,
UnSelectedState
),AllState
)

So if Hasonevalue() is true, it should give me the Value of "SelectedState","UnSelectedState", which is working fine but it doesn't give me "AllState" value for else statement. 

[v-danhe-msft · Accepted solution]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft]

Hi @Anonymous,

From your formula, if the HASONEVALUE() is false, it will give  you the "AllState" value, you could check if the formula

HASONEVALUE( Qualifiers[State] ) has the false value.

Also, could you please share a pbix to have a test if possible? You could upload your file to OneDrive or Dropbox and send the link here.

Regards,

Daniel He