Forum Discussion

Ak_Pikachu's avatar
Ak_Pikachu
Frequent Visitor
3 years ago
Solved

Conditional Text box based on conditional format

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...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
Ak_Pikachu
Frequent Visitor
3 years ago

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"