Forum Discussion

mrslyfox911's avatar
mrslyfox911
Advocate III
3 years ago
Solved

Adaptive Text field

Hello, I have a table with a test description of parameter IDs. How can I make the description text field appear only when a specific ID is selected in the filter? If the id is not selected, the tex...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi mrslyfox911 ,

    According to your description, here's my solution.

    Create a measure:

    Measure =
IF (
    COUNTROWS ( ALLSELECTED ( 'Table'[ID] ) ) = COUNTROWS ( ALL ( 'Table'[ID] ) ),
    BLANK (),
    MAX ( 'Table'[TXT] )
)

    Get the correct result:

    I attach my sample below for your reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vicky_'s avatar
vicky_
Super User
3 years ago

By filter, do you mean a slicer? 
You can try something like:

IF(SELECTEDVALUE([ID]) = specificID, 
    // show your description,
    BLANK()
)
  • mrslyfox911's avatar
    mrslyfox911
    Advocate III
    3 years ago

    Hi vicky_ 

    slicer can be as well. 

    formula not working for me 

    • vicky_'s avatar
      vicky_
      Super User
      3 years ago

      Hey, sorry to hear that. Could you you describe the issue with the formula?