Conditional Text box based on conditional format

[Ak_Pikachu]

I have a question, I want to display a text box visual, on condition basis

If none of values in Red: "Everything Ok"
If some values in Red: "Correct the Values".
I have a DAX that works in Table visual,but I need a text box visual conditionally

Please Help

A	Everything Ok
b	Everything Ok
c	Everything Ok
d	Correct the Values

I got d in red based on a condition

[Ak_Pikachu]

For Better Idea of what am doing . Please check this
https://community.powerbi.com/t5/Desktop/Conditional-Formatting-based-on-text-fields-Help/m-p/284066...


Please help if this can done.

[Anonymous]

OK i see.

Then use the same measure you've used for the red formating and put it in a card

Check Values = 
VAR __tableAValue = SELECTEDVALUE ( TableA[Value] )
VAR __tableBValue = SELECTEDVALUE ( TableB[Value] )
RETURN
IF ( __tableAValue <> __tableBValue, "Correct the Values","Everything OK" )

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[Ak_Pikachu]

Hi,

I have tried but its working fine when names are added to table visual and this measure, But this measure alone in a card visual showing Always OK, even if the values are not matching

Please help if there is a way to do.

[Anonymous]

Could you share the pbix file you are working on so we can take a look?

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[Ak_Pikachu]

Hi @Anonymous,
Test_format Here is the Pbix,

Please look into it.

[Anonymous · Accepted solution]

Hi

Sorry, but only now i understood your problem.

So, i created a calculated column that checks if the value from table1 matches table2

Then created a measure that checks if any missmatched values are in scope

Hope it helps

FILE:
https://we.tl/t-mHWtCBvMDy

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂

[Ak_Pikachu]

Thanks @Anonymous  for the Solution,

Worked like a charm

[Ak_Pikachu]

Thanks for the reply, 

This has to be dynamic , I will have the values get changed.
Not static, what ever the values in red they have to be considered
If any values in red Display for "Correction"
if no red Display "All Okay"

[Anonymous]

Hi

Just create a measure to check if the value "d" is in your column

Your Measure = 
IF("d" in VALUES('yourtable'[yourcoulumn]), "Correct the Values","Everithing OK") 

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂