Adaptive Text field

[mrslyfox911]

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:

ID	TXT	Value
101	Orange	1
102	Apple	1
103	Coconut	1
104	Apricot	1
105	Straweberry	1

Filter based on ID column.

[v-yanjiang-msft · Accepted solution]

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_]

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

IF(SELECTEDVALUE([ID]) = specificID, 
    // show your description,
    BLANK()
)

[mrslyfox911]

Hi @vicky_ 

slicer can be as well. 

formula not working for me 

[vicky_]

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