Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

DAX Switch True

I am using a Switch True evaluation and am getting all results back in the expected manner, with the exception of one item. I have tried moving the line to a different spot in the evaluation, but the...
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous ,

 

 

I think  for Non Error     Spares MGMT'[UX300] is  BLANK ().

 

 

Try this :

 

 

Missed Obligation =
VAR a = 'Spares MGMT'[Line_Released] = "1"
    && 'Spares MGMT'[Error_any] = "0"
    && 'Spares MGMT'[Spares_DM] = "01_SPARES_MISSED_OBLIGATION"
    && 'Spares MGMT'[UX300] = "0"
RETURN
    SWITCH (
        TRUE (),
        'Spares MGMT'[Line_Released] = "1"
            && 'Spares MGMT'[Error_any] = "0"
            && 'Spares MGMT'[Spares_DM] = "01_SPARES_MISSED_OBLIGATION"
            && 'Spares MGMT'[UX300]
                = BLANK (), "NonError",
        a
            && 'Spares MGMT'[EXPORT] = "0", "Domestic",
        a
            && 'Spares MGMT'[EXPORT] = "1", "Export",
        a
            && 'Spares MGMT'[UX300] = "1", "UX300",
        'Spares MGMT'[Line_Released] = "1"
            && 'Spares MGMT'[Error_any] = "1"
            && 'Spares MGMT'[Spares_DM] = "01_SPARES_MISSED_OBLIGATION", "Error",
        "N/A"
    )

 

 


Regards,

Harsh Nathani


Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!