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! 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

      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's avatar
        Anonymous
        Not applicable
        3 years ago

        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! 🙂