Suggested values - several values instead of only one (expected one based on my expression)

[DroidTeo]

Hello!
I'm going to explain my structure...

1. The table "Users" contains different attributes + one called Region ,
2. another table named "TeamLeaderByRegion" -> it is a table that connect the region with a team leader (users) -> a uses can be leader of several regions
   
   
3. I have a table "Report" within a column "Users" name "Inspector" -> this Users has as attribute a column "Region" -> where he works
   and another column "Manager" -> the TeamLeader of the region.. 

Inside the report form, I want to show the team leaders based on the selected inspector, and so I've addeed the following formula inside the field "Suggested values":

SELECT(TeamLeaderByRegion[Team Leader], IN([_THISROW].[Inspector].[Region], TeamLeaderByRegion[RegionTeamLeader]))

But instead of obataining only the leaders of that particular region, I've all the time all the leaders of all regions.

Why? 

[DroidTeo · Accepted solution]

I've changed like this:

LIST(LOOKUP([_THISROW].[Inspector].[Region],"TeamLeaderByRegion", "RegionTeamLeader", "Team Leader"))

I don't understand (ok, I didn't investigate yet), why in this way it works..