Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Amitkr174
Helper III
Helper III

Dax Help required

‎10-12-2020 02:41 AM

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.

Labels:
Message 1 of 2
412 Views
0
1 REPLY 1
themistoklis
Community Champion
Community Champion

‎10-12-2020 03:54 AM

@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()
)
Message 2 of 2
375 Views
0

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

View All