topic Different collor compare values in DAX Commands and Tips

Different collor compare values

stefan321 — Sat, 02 Dec 2023 13:04:16 GMT

i have two tables, lets say TableA & TableB

TableB contains allowed Version numbers like 13.1.5

TableA contains also some different Version number, but only allowed Version numbers (check from TableB) should be highlighted in TableA in "green" color.

If Version number is not in TableB, then hightlight Version number in "red" in TableA

How to do that?

Thanks a lot!

Re: Different collor compare values

Fowmy — Sat, 02 Dec 2023 14:24:19 GMT

stefan321

Suppose you have your Version numbers from Table one on a table visual, Create the following measure, add conditional formatting > choose background, pick Field value as the Format Style and pick this measure.

CF = IF( NOT CONTAINSROW( values(table2[version number] ), selectedvalue( table2[version number] ) , "red" )

Re: Different collor compare values

stefan321 — Sat, 02 Dec 2023 15:51:06 GMT

Thanks for your quick feedback!

unfortunately i get an error:
"Too few arguments were passed to the IF function. The minimum argument count for the function is 2"
Could you please check your code? think something is missing but i am not able to find it.

Re: Different collor compare values

Fowmy — Sat, 02 Dec 2023 16:15:59 GMT

Please use the following measure:

CF =
IF (
NOT CONTAINSROW (
VALUES ( table2[version number] ),
SELECTEDVALUE ( table1[version number] )
),
"red"
)