Forum Discussion

Amitkr174's avatar
Amitkr174
Icon for Helper III rankHelper III
5 years ago

Dax Help required

I need help in creating a measure based on the below condition:-

1st condition….Instructor=Delivery but not equal to Order, then “Yes”

2nd Condition… Instructor ,Delivery, Order all are different then “Yes” Please suggest.

Need Help DAX measure

1 Reply

  • themistoklis's avatar
    themistoklis
    Icon for Community Champion rankCommunity Champion
    5 years ago

    Amitkr174 

     

    If Delivery, Instructor and Order are all columns and not values you can try the following formula.

     

    Create a column not a measure.

     

    Column =
SWITCH (
    TRUE (),
    'Table'[Instructor] = 'Table'[Delivery] && 'Table'[Instructor] <> 'Table'[Order], "Yes",
    'Table'[Instructor] <> 'Table'[Delivery] && 'Table'[Instructor] <> 'Table'[Order]) && 'Table'[Delivery] = 'Table'[Order] &, "Yes",
    BLANK()
)