Forum Discussion

stefan321's avatar
stefan321
Icon for Helper I rankHelper 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
Icon for Super User rankSuper 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" )