cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Finnair
Helper I
Helper I

How to find matches in two columns with DAX?

I have a situation, where i have a column "A. ALL ROWS" with multiple ISSUE ID:s (An ISSUE ID can exist multiple times). Then I have a column "B. PRODUCT ISSUE ID" where the ISSUE ID is mentioned only few times (once or more).

The column "B. PRODUCT ISSUE ID" is the Primary Column which counts.

I need to mark all the rows with "true" or "false" in Column C, if the B column's ISSUE ID is found in A column.

How would I do it?

 
 

columns.JPG

 

1 ACCEPTED SOLUTION
Fowmy
Super User IV
Super User IV

@Finnair 

Add the following column to your table:

C.Match Found = 

IF( 
    Table[A. ALL ROWS] in ALL(Table[B. PRODUCT ISSUE ID]),
    TRUE(),
    FALSE()
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

2 REPLIES 2
Fowmy
Super User IV
Super User IV

@Finnair 

Add the following column to your table:

C.Match Found = 

IF( 
    Table[A. ALL ROWS] in ALL(Table[B. PRODUCT ISSUE ID]),
    TRUE(),
    FALSE()
)

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂


Website YouTube  LinkedIn

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Website   YouTube    LinkedIn

View solution in original post

Thank you! That was quick 🙂

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors