DAX measure SELECTEDVALUE to FILTER a table excluding SELECTEDVALUE

[witbi]

I have a table which lists team members organising events. I would like to create a measure that allows me to select one of the team members and filters a matrix to display the Other Team Members that are organising the events.

I tried to use SELECTEDVALUE and LOOKUPVALUE but they error out due to the multiple events. 
Any ideas or assistance most appreciated.

Team-Event table

Id	Team	Event
1	Jane	A
2	Vic	B
3	Bob	B
4	Pam	C
5	Vic	A
6	Nel	B
7	Vic	C
8	Pete	B
9	Bob	A
10	Nel	C

Slicer showing all the team members

Example: select 'Nel' who is organising event B and C

Team members

Jane

Vic

Bob

Pam

Nel

Pete

Example: select 'Nel' who is organising event B and C returns an Expected result

Other Team Members filtered by event B and C but excludes 'Nel'

Event	Team
B	Bob
B	Pete
B	Vic
C	Pam
C	Vic

[wdx223_Daniel]

[witbi]

Thanks @wdx223_Daniel I wonder if there's a way to use this measure to filter a matrix visual? In the matrix I'd like to display a list of other team member names and the count of events they are linked to.

[wdx223_Daniel]

[witbi]

Thanks @wdx223_Daniel. Is there a way to make the table work without explicitly showing event? Just a table with Other team members and count of events they are linked to?

[wdx223_Daniel]

can use this code to get the result directly without viusal filters

[lbendlin]

I would recommend using a disconnected table for the team member slicer. Then

- get the selectedvalue() from the slicer (make sure it is single selection)

- collect all events for that team member

- collect all team members for these events

- remove the selected value via EXCEPT or FILTER