Compare 2 columns in separate tables (T/F), use conditional formatting to highlight differences

[Anonymous]

I have 2 tables named Predictions and Actual, both of them have a coloum named Winner. Predictions made by users are stored in the Predictions table and the Actual winner is stored in the Actual table. They have a one-to-one relationship.

The goal is to put these values side by side (both T/F string vales) in a table visual and compare them. I'm hoping to have either a calculated column or a measure which returns true if the values match or false othwewise.

Then we use this calculated value to conditionally format the predictions coloum to highlight the incorrect predictions. 

What i expected to a simple comparison is not looking so simple, anyone come across this issue before? Thanks for your time. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

Create measures and conditional formatting as below.

Measure = IF(SELECTEDVALUE(Predictions[winner])=SELECTEDVALUE(Actual[winner]),TRUE(),FALSE())

Measure 2 = IF([Measure]=TRUE(),1,0)

Best Regards,

Jay

[aj1973]

A dummy PBI would help the community to understand your request