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

Fowmy's avatar
Fowmy
Super User
2 years ago

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