Getting virtual column count of using table key reference in another table enum list

[ComfortablyNumb]

Hi there,

Trying to associate the following (have a 'Events' table and a 'Players' table)

There are many events, and the 'Events' table consists of an enum list of [Players]

To be clear: 

Events[Players] (with [Players being an enum list of players added to a event)

I'm trying to add a virtual column in the Players data definition to be able to trawl all the Events and identify all the events they played. Tried the following with no luck:

SELECT(Events[Players], Players[Row ID]=[_THISROW])

Eventually, once I have the right command, I will create another column which is the sum of that total of events. Also need to put a filter on the select too at some stage (eg date range from 1/1/2023 to 31/12/2023)

Little help please from some experts, thank you.

Thank you.