Forum Discussion
Solved
Need help with measure
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 InterDomest...
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!!- 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:
Hi InsightSeeker ,
Use below DAX in a calculated measure:
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: