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 InterDomest...
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:

     

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?