topic Re: Conditional formatting DAX in DAX Commands and Tips

Conditional formatting DAX

Back2Basics — Mon, 06 Jun 2022 14:57:47 GMT

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.

Re: Conditional formatting DAX

tamerj1 — Mon, 06 Jun 2022 19:39:31 GMT

Hi Back2Basics

any relationship between the two tables?

Re: Conditional formatting DAX

Back2Basics — Tue, 07 Jun 2022 08:37:29 GMT

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

Re: Conditional formatting DAX

tamerj1 — Tue, 07 Jun 2022 09:09:50 GMT

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

Re: Conditional formatting DAX

Back2Basics — Tue, 07 Jun 2022 12:51:53 GMT

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

Re: Conditional formatting DAX

tamerj1 — Tue, 07 Jun 2022 13:04:31 GMT

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