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

Hi Anonymous,
Test_format Here is the Pbix,

Please look into it.

Anonymous's avatar
Anonymous
Not applicable
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 Anonymous  for the Solution,

    Worked like a charm