I have 3 Tables - Defects - Departments - Employee
In the Defects Form I ask for the Department (Ref) of the Employee and for the Name (Ref) of the Employee.
I made it so, that when I choose a Department, Only the Employees of that Department are shown.
When I need to create a new Employee, it should give me the Department I choose before.
I thought it would be just
=ANY(SELECT(Departments[Key] , [_THISROW].[Department] = [Key])) But it doesn’t work.