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 t...
Need Help DAX measure
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()
)