Different collor compare values

[stefan321]

Hi

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!

[Fowmy]

@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" )

[stefan321]

Hi

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.

[Fowmy · Accepted solution]

Please use the following measure:

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