How to pull TEXT data from your data set and put it on a Dashboard

[Glibberg]

I have a data like this and filter for ID on a Dashboard.

How to make a card on a dashboard such that when select ID on the filter, for example 1001, this card shows 'abc', but when I select 2000 this card shows 'xyz'? Thank you!

id	text
1001	ABC
1001	abc
1001	abc
2000	xyz
2000	xyz
2000	xyz

[Glibberg]

Thank you. 

[olgad · Accepted solution]

Hi,
put first text?

what do you want to see when nothing is selected in the filter?

[Glibberg]

Thank you. When nothing is selected I want to see a blank page.

[olgad]

Create this measure:  Measure  = If(HASONEVALUE(sel[id]), FIRSTNONBLANKVALUE(sel[text],max(sel[text])))
then you see 

instead of blank you could have "Select ID" or anything you want.

[amitchandak]

@Glibberg , You need measure like

Max(Table[Text])

or

Concatenatex(Values(Table[Text]) , [text])