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! Go to Solution.
This?
FILTER(
"Servicios Equipos",
IN([_THISROW].[EQUIPO],[EQUIPOS ASIGNADOS])
)
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.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |