DAX For Multiple IF Statements and Conditions

[markefrody]

Hi,

I am using this sample table:

I would like to set-up a DAX wherein:
If Check 1 = "Export" show "Export", 
If Check 1 = "Domestic show "Domestic",

If Check 1 = "Others", go to Check 2,
If Check 2 = "Yes", show "Import",
If Check 2 = "No", go to Check 3,
If Check 3 = "Yes", show "Import",

If Check 3 = "No", show "Unclassified"

Here is a sample result when the above is used:

Appreciate your kind assistance.

Best regards,
Mark V

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Result CC =
SWITCH (
    TRUE (),
    Data[Check1] = "Export", "Export",
    Data[Check1] = "Domestic", "Domestic",
    Data[Check2] = "Yes", "Import",
    Data[Check3] = "Yes", "Import",
    Data[Check3] = "No", "Unclassified"
)

[markefrody]

Hi @Jihwan_Kim. Thank you. Works perfectly!