Forum Discussion

InsightSeeker's avatar
InsightSeeker
Helper III
2 years ago
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 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

 

InterDomesticresult
OutboundInternational
OutboundInternational
OutboundInternational
DomesticDomestic
RegionalInternational
InboundDomestic
InboundDomestic
InboundDomestic
InboundDomestic

 

Need Help
Show and Tell
  • rajendraongole1's avatar
    rajendraongole1
    2 years ago

    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's avatar
    Anand24
    2 years ago
    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:

     

4 Replies

  • rajendraongole1's avatar
    rajendraongole1
    Super User
    2 years ago

    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's avatar
    Anand24
    Super User
    2 years ago
    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:

     

  • bevicor's avatar
    bevicor
    Regular Visitor
    2 years ago

    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's avatar
      InsightSeeker
      Helper III
      2 years ago

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