I was wondering if someone could help me with a Dependent Dropdown expression.
I have three tables: List of Equipments, List of tasks (each task has a column with a list of all the equipments that have this task assigned)
My third table has individual rows for each task assigned to each equipment.
On this third table, I have a Ref column for all the equipments, and a Services column where I want to see all the Services to which the selected equipment is assigned.
I have tried Valid If expressions for the Services column to get a Dependent DropDown, but none of my expressions worked. This is what Ive tried so far:
SELECT(Servicios equipos[Servicio],(IN([EQUIPO],Servicios equipos[Equipos asignados])))
FILTER(Servicios Equipos,IN([_THISROW].[EQUIPO],SERVICIOS EQUIPOS[EQUIPOS ASIGNADOS]))
IN( [_THIS], SELECT(Regions[Country], [_THISROW].[Lead Region] = [Region]))
Any ideas or recommendations will be greatly appreciatted.!!