Forum Discussion

andreazambon's avatar
andreazambon
Icon for Helper V rankHelper V
3 years ago
Solved

Mark a value if it match between 2 tables

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 ORDERPRODUCTION ORDER

ODV1

ODP1
ODV1ODP2
ODV2ODP3
ODV3ODP4

 

T2

CUSTOM ORDERPRODUCTION ORDER

ODV1

ODP1
ODV3ODP4

 

 

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 ORDERPRODUCTION ORDER

ODV1

ODP1
ODV1ODP2
ODV2ODP3
ODV3ODP4

 

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

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.