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]
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
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.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |