Forum Discussion

stefan321's avatar
stefan321
Helper I
2 years ago
Solved

Different collor compare values

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...
  • Fowmy's avatar
    Fowmy
    2 years ago

    Please use the following measure:

     

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

stefan321's avatar
stefan321
Helper I
2 years ago

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's avatar
Fowmy
Super User
2 years ago

Please use the following measure:

 

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