Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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.
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.
By filter, do you mean a slicer?
You can try something like:
IF(SELECTEDVALUE([ID]) = specificID,
// show your description,
BLANK()
)
Hey, sorry to hear that. Could you you describe the issue with the formula?
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |