Forum Discussion

nb790410's avatar
nb790410
New Member
1 year ago

Comparing two tables within a dashboard

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 highligh...
Need Help
danextian's avatar
danextian
Super User
1 year ago

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.