Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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. 

1 ACCEPTED SOLUTION
v-jayw-msft
Community Support
Community Support

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)

1.PNG

2.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.

View solution in original post

2 REPLIES 2
v-jayw-msft
Community Support
Community Support

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)

1.PNG

2.PNG

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
aj1973
Community Champion
Community Champion

A dummy PBI would help the community to understand your request

Regards
Amine Jerbi

If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors