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

    Please use the following measure:

     

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

3 Replies

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