Need help with measure

[InsightSeeker]

I treid creating the below measure but i am not getting the desired results.

If Table 1 InterDomestic is "Outbound" or "Regional" or "International" return "International"

If Table 1 InterDomestic is "Inbound" or "Domestic" return "Domestic"

IntDom =
VAR _InterDomesticValue = SELECTEDVALUE('Table1'[InterDomestic])
RETURN
IF(_InterDomesticValue = "Domestic", "Domestic",
IF(_InterDomesticValue = "Inbound", "Domestic",
IF(_InterDomesticValue = "Outbound", "International",

IF(_InterDomesticValue = "International", "International",
IF(_InterDomesticValue = "Regional", "International"
,"International"))))

InterDomestic

Outbound

Outbound

Outbound

Domestic

Regional

Inbound

Inbound

Inbound

Inbound

Result

InterDomestic	result
Outbound	International
Outbound	International
Outbound	International
Domestic	Domestic
Regional	International
Inbound	Domestic
Inbound	Domestic
Inbound	Domestic
Inbound	Domestic

[rajendraongole1 · Accepted solution]

Hi @InsightSeeker - Use the below measure, this checks if the value of "InterDomestic" is "Outbound", "Regional", or "International". If it is, it returns "International", otherwise, it returns "Domestic".

IntDom =
VAR _InterDomesticValue = SELECTEDVALUE('Table1'[InterDomestic])
RETURN
IF(
_InterDomesticValue = "Outbound" ||
_InterDomesticValue = "Regional" ||
_InterDomesticValue = "International",
"International",
"Domestic"
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[Anand24 · Accepted solution]

Hi @InsightSeeker ,
Use below DAX in a calculated measure:

Result = 
SWITCH( 
    TRUE(),
    MAX(TableName[InterDomestic]) IN {"Outbound", "Regional", "International"}, "International",
    MAX(TableName[InterDomestic]) IN {"Inbound", "Domestic"}, "Domestic"
)

Output:

[rajendraongole1 · Accepted solution]

Hi @InsightSeeker - Use the below measure, this checks if the value of "InterDomestic" is "Outbound", "Regional", or "International". If it is, it returns "International", otherwise, it returns "Domestic".

IntDom =
VAR _InterDomesticValue = SELECTEDVALUE('Table1'[InterDomestic])
RETURN
IF(
_InterDomesticValue = "Outbound" ||
_InterDomesticValue = "Regional" ||
_InterDomesticValue = "International",
"International",
"Domestic"
)

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

[bevicor]

Does it have to be a measure? I think your DAX will work if you make a calculated column instead of a measure and just change it slightly.

IntDom =
VAR  InterDomesticValue = 'Table1'[InterDomestic]
RETURN
IF(_InterDomesticValue = "Domestic", "Domestic",
IF(_InterDomesticValue = "Inbound", "Domestic",
IF(_InterDomesticValue = "Outbound", "International",

IF(_InterDomesticValue = "International", "International",
IF(_InterDomesticValue = "Regional", "International"
,"International"))))

[InsightSeeker]

@bevicor I don't want to create a calculated column; instead, I would prefer to achieve it via a measure. Is it possible?