Dependent drop down list

[Jacek1]

Hi,

I'm working on creating a dropdown list in one table that is dependent on another table containing employee information.

In the second table, I'd like to implement a dropdown list that dynamically populates with active employees based on the team selected in the respective row. For instance, if I choose "Team A," I want the dropdown to display options such as Jane and Joe for selection (not Daniel as he is inactive).

Any help will be apprecieted.

[AleksiAlkio]

Try something like SELECT(Employees[Employee],AND([Team]=[_THISROW].[Team],[Status]="Active"))