Mark a value if it match between 2 tables

[andreazambon]

Hi there. 

I have 2 tables T1 and T2. They have different columns but some of them are in common. Values could be different but T2 surelly contains values that are in T1 too. T1 could have values that are missing in T2.

Take this example:

T1

CUSTOM ORDER	PRODUCTION ORDER
ODV1	ODP1
ODV1	ODP2
ODV2	ODP3
ODV3	ODP4

T2

CUSTOM ORDER	PRODUCTION ORDER
ODV1	ODP1
ODV3	ODP4

I need a view which contains all T1 values, but marks with green fill the values whic are also in T2, and the others in red.

So:

VIEW (here i mark the text for sample):

CUSTOM ORDER	PRODUCTION ORDER
ODV1	ODP1
ODV1	ODP2
ODV2	ODP3
ODV3	ODP4

The view that is near my goal is a pivot table.

With anti merge I create a table which contains all the value of T1 that are not included in T2.

Any suggestion?

Thankyou

[v-binbinyu-msft · Accepted solution]

Hi @andreazambon ,

Please try below steps:

1. create two measure with below dax formula

CO Color =
VAR co =
    SELECTEDVALUE ( T1[CUSTOMER ORDER] )
VAR tmp =
    VALUES ( T2[CUSTOMER ORDER] )
RETURN
    IF ( co IN tmp, "green", "red" )

PO Color =
VAR co =
    SELECTEDVALUE ( T1[PRODUCTION ORDER] )
VAR tmp =
    VALUES ( T2[PRODUCTION ORDER] )
RETURN
    IF ( co IN tmp, "green", "red" )

2. add a table visual with T1 fields, and configure the fields conditional format 

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.