Getting value from a field based on a corresponding column

[Anonymous]

Hello, I'm struggling with something that seems very simple yet I spent quite some time on it and have not found a straightforward answer.

What I need to do is to extract a value from a table based on a value of a corresponding column. The table has 2 columns: id and name. I want to use it for labelling measures on a chart which is based on various tables. So it would be something like = name(id=2). Can someone help?

[sunny_talwar · Accepted solution]

May be this

Concat(DISTINCT {<id = {2}>}name)

or

Only({<id = {2}>}name)

[Anonymous]

Thanks, I used the second one and it did the trick 🙂