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 text field did not display anything.

Data Example:

IDTXTValue
101Orange1
102Apple1
103Coconut1
104Apricot1
105Straweberry1

Filter based on ID column.

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.

4 Replies

  • 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()
)
      • vicky_'s avatar
        vicky_
        Super User
        3 years ago

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

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    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.