Lookup based on a dropdown from different table

I have 2 tables.
in the first table, in the field “CittaSL”, I would take the values from another table in the column “Comune”. I have solved this with type “Ref”.
Now when I take a value from “CittaSL”, I would take the corresponding value also for other 2 fields in the second table “ProvinciaSL”.

I have tried with these formulas but not works:
IN( [_THIS], SELECT(GA_ANA_Comuni[PV], [_THISROW].[CittaSL] = [Comune]))
ANY(SELECT(GA_ANA_Comuni[PV], ([Comune] = [_THIS].[CittaSL])))
SELECT(GA_ANA_Comuni[PV],[Comune]=[_THISROW].[CittaSL])

3X_e_6_e652216233839f80a311d4bd9d9f2416145011b5.jpeg

Solved Solved
0 10 450
1 ACCEPTED SOLUTION

View solution in original post

10 REPLIES 10
Top Labels in this Space