Access a Column from Dynamic Value in Text Box

[Hoping]

I want to access Column 2 of a table based on Column 1 in the same table in Dynamic Value Updates of a Text box.

I want to get Column 2 value where Column 1 value = "A"

What prompt should I use in the Dynamic Value Update to get the contents of Column 2 corresponsing to value "A" in Column 1.

Column 2 is basically a text which I want to display for specific values in Column A.

[wini_R]

Hi @Hoping,

not sure if I get it right as the question is too vague but you might try this formula:
CALCULATE(SELECTEDVALUE(tableName[Column2]), [Column1] = "A")

If that is not what you need, please provde more details or an example.

[lbendlin]

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?