Dependent Enumlist

[Yeyo1976]

"Hi, I have a table called Libro de Clases, which is filled in the columns Profesora, Nivel and Jornada using the formula LOOKUP(USEREMAIL(),Profesoras, EMail,Nombre).

I need is to be able to select the list of students that meet the three criteria: Teacher, Level and Day, either through an enum list or another alternative that you can suggest.

Something like this, but with the referenced data as I show early.

Please keep the language simple, as I am quite new to this program

[AleksiAlkio]

Let’s assume the “Pick a continent” would be an EnumList column. Then the dependent dropdown for the “Pick a country” needs to be..

SELECT(Documents[Country],IN([Continent],[_THISROW].[Pick a continent]))

[Yeyo1976]

Thanks!

What I need is that in the second pic, below Jornada, show the enumlist of students dependant of theese filters: Profesora, Niveles y Jornada.

The real data are the first 2 pics, could you give me a hand?