Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |