Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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.
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.
User | Count |
---|---|
94 | |
86 | |
78 | |
70 | |
63 |
User | Count |
---|---|
114 | |
101 | |
97 | |
66 | |
59 |