Comparing two tables within a dashboard

[nb790410]

I have a power bi dashboard and within that two separate tables with data displayed on one tab, the tables in some case have an identifer that matches in both tables, where this is i want to highlight those green and where we have a non match highlight them in RED, is this possible?

[v-sdhruv]

Hi @nb790410 ,
Just wanted to check if you had the opportunity to review the solution provided by the Super User?
If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Fell free to reach out in case of any issues.
Thank you.

[v-sdhruv]

Hi @nb790410 ,
Just wanted to check if you had the opportunity to review the solution provided by the Super User?
If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Fell free to reach out in case of any issues.
Thank you.

[v-sdhruv]

Hi @nb790410 ,
Just wanted to check if you had the opportunity to review the solution provided by the Super User?
If his response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[danextian]

Hi @nb790410 

Create a separate dimensions table that contains a complete list of IDs and relate that to the two other tables in a one to many single direction relationship

Add the column from the dimension table to a visual. Create this measure and add it to the visual as well.

Test = 
DISTINCTCOUNT ( T1[ID] ) + DISTINCTCOUNT ( T2[ID] )

Apply conditional background conditional formatting to the ID column based on the value of the measure above

Please see the attached sample pbix.