Select only pulls in 1 item ever

I have this formula runing in table called Reports. Staff[Name] is a NAME type column. Report[Staff] is an ENMULIST and Base Type is Name

Select(Staff[StaffID],IN([Name],ANY(Select(Report[Staff],TRUE))))

If Report[Staff] = Bob
Then the result is Bob

If Report[Staff] = Bob, John, Simon
Then the result is Bob

If Report[Staff] = John, Simon
Then the result is John

The formula is in a Virtual Column of type Ref because Staff[StaffID] is the Key Column. Presumably irrelevant?

Tried Select(Staff[StaffID],IN([Name],[_ThisRow].[Staff])) but its the same result

Driving me nuts. Can’t see the issue.

This:

Select(Staff[StaffID],IN([Name],ANY(Select(Report[Staff],TRUE))))

should be:

Select(Staff[StaffID],IN([Name],Select(Report[Staff],TRUE)))

or:

Select(Staff[StaffID],IN([Name],Report[Staff]))
1 Like