Get the value of two another column in same table when i select the enum list

Get the value of two another column in same table when i select the enum list

I am having the group table

Group members has Enumlist ,base type has text ,i am using select statement in valid if

I want to show the Email IDand phone number of the members selected in Group members column

Suggest any expression ,

List of email IDs:

SELECT(
  some-table[Email ID],
  IN([id-column], [_THISROW].[Group members])
)

or possibly:

[Group members][Email ID]

List of phone numbers:

SELECT(
  some-table[phone number],
  IN([id-column], [_THISROW].[Group members])
)

or possibly:

[Group members][phone number]
1 Like

Steve ,the expression is not getting the value,
I have changed the Group member has enumlist with ref the
employee table with Email Id as key column
image
In Group members name i am using the value of Group Member so i am getting the Email ID

I need the Employee Name of the group member i select in Group member column.

This makes no sense. Please restate.

I have changed the Group member Column has enumlist with base type has ref of the
employee table ,where the Email Id is the key column.