DAX - Return 2 rows of a column with a lookup

[Anonymous]

Community,

In table1 below I have a CASE ID column and a CASE ID REF column.

In table1 CASE ID REF represents the CASE ID that we would like the compare the CASE ID in that row to.

I would like to have a measure that returns the both the CASE ID's of both numbers referenced in the row (CASE ID and CASE ID REF).

Example:

IF I were to filter on CASE ID 2 in Table1, I would like to have a measure that returns the CASE ID and the corresponding CASE ID of the CASE ID REF, such that it would return:

CASE ID

1

2 

Any help is appreciated!!

[v-chuncz-msft · Accepted solution]

@Anonymous 

You may take a look at the post below.

https://community.powerbi.com/t5/Desktop/Tricky-Slicer-Options/m-p/573381#M270846

[Cmcmahan]

Measures can only return 1 value, by design.  You can easily set up two measures that return each value, or a measure that returns both values as a concatenated string, but not 2 values.

ConcatenateIDandREF = SELECTEDVALUE(table1[CASE ID]) &" : "& SELECTEDVALUE(table1[CASE ID REF])

This will return "2 : 1" if you filter on CASE ID = 2.