Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
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