Dependent dropdown for Ref value in List

Hi everyone,
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.!!

Solved Solved
0 2 237
1 ACCEPTED SOLUTION

Steve
Participant V

This?

FILTER(
  "Servicios Equipos",
  IN([_THISROW].[EQUIPO],[EQUIPOS ASIGNADOS])
)

View solution in original post

2 REPLIES 2

Steve
Participant V

This?

FILTER(
  "Servicios Equipos",
  IN([_THISROW].[EQUIPO],[EQUIPOS ASIGNADOS])
)

Thanks so much @Steve for taking your time to help !

Sometimes we miss the obvious and need an external eye to see whats wrong.

Top Labels in this Space