Conditional formatting DAX

[Back2Basics]

I'm trying to add some conditional formatting to a matrix. I have a matrix that has a series of outcomes and the count of Unique_ID for each outcome. I also have a dropdown on the page so that users can select an ID and the matrix highlights the outcomes for that particular ID - this is working fine using the following DAX: 

Matrix select = IF(ISFILTERED('Report measures'[Unique ID]),IF(SELECTEDVALUE('Report measures'[Unique ID]) IN VALUES (Workbook[Unique ID]), 1))

& then applying the appropriate conditional formatting. 

I also have a table which has a list of 'linked' ID's. So this looks something like this:

Unique ID	Linked ID
INT001	INT172
INT001	INT250
INT002	INT015

I want to replicate the matrix that is working, as described above, so that when an ID is selected it highlights the outcomes for the Linked ID's. I have been trying several things but just can't quite get it to work. Everything is still assocaited with the Unique ID filter rather than filtering the Linked ID. 

Any help is very much apprecaited.

[tamerj1]

Hi @Back2Basics 

any relationship between the two tables?

[Back2Basics]

Hi @tamerj1 - yes, there is a relationship between the Unique ID columns in each table. The table with the linked Id's is standalone, so could remove the relationship if this is the way to do it

[tamerj1]

@Back2Basics 
I'm having some difficulties replicating your matrix. Would you please provide some sample data and perhaps some screenshots to understand exactly what is required. Thank you

[Back2Basics]

I'm going down a different route now. Unfortunately I can't share any of the real data. 

[tamerj1]

@Back2Basics 
Sorry for the misunderstanding. I mean If you can create and share a sample dummy data that simulates your situation along with example expected results