Dax Help required

[Amitkr174]

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.

[themistoklis]

@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()
)