Show duplicates from different data sets

[fingalbrad]

Hi,

There is a similiar post to this but not exactly what I want.

I have two Data sets. One containing M3&M4 maintenance notifications and the equipment number i.e

M3&M4                                                                                                     M2

Type     Reasons                      Notification No.                                         Type   Reasons                  Notification No.

M3       12345678abc                     ######                                                M2     12345678abc                      ######

M3       12345677abc                      ######                                               M2     12345677abc                      ######

M4       12345678abc                       ######                                              M2     12555555abc                      ######

M4       12345676abc                       ######                                              M2     12444444abc                      ######

I want to create a table which shows when the reasons from M3&M4 data set matches the reasons form the M2 data set. Then I want a table showing the M2 & M3/M4 notification numbers and reasons. 

Can I create a custom column which checks for matches ?

[TeigeGao]

Hi @fingalbrad ,

According to your description, my understanding is that you want to filter the data in M3&M4 whose reason matches that in M2, in this scenario, we can use the following DAX query:

Table = FILTER('M3&M4','M3&M4'[Reasons] in VALUES(M2[Reasons]))

Best Regards,

Teige

[fingalbrad]

Thank you,

Will that only show the values from 'M3 & M4'? I want to show all those that match so list M2,M3 & M4 that have the same  equipment-part number. 

[fingalbrad]

Reason number sorry...not equipment-part