Highlighting the value of a column if it matches with future values in another column

[SwathiJanu]

There are 2 columns namely current and new. If values of new column matches with any of the future entries of Current, it means failed and If we find one such entry - the values are to be highlighted. I need Dax solution for this

[FreemanZ]

hi @SwathiJanu 

not sure if i fully get you.

supposing you have a data table like:

try to 

1) plot a table visual with the two culumns

2) apply the conditional formating of the background color for the new column with a meausre like:

measure = 
IF(
    MAX(data[new]) IN ALLSELECTED(data[current]),
    "Red"
)

it worked like: