I need help to use Switch in Column in order to dinamically change the Dimension

[apolotakeshi]

Hi all I have a Table4 in which I select the value that I want, it is either 1 or 2.

if it is 1, i want the column to show the values that exists in Table_01 column Dbase17, else I want them to return the Table_02 data.

how can i do it?

here is what I have so far:

Dinamic_Column =
if(
SELECTEDVALUE(Table4[Value])="1"
;RELATED(Table_01[Dbase17])
;RELATED(Table_02[Dbase16])
)

also tried:
SWITCH(FIRSTNONBLANK('Table4'[Value];1)
;"1"; RELATED(Table_01[Dbase17])
;"2"; RELATED(Table_02[Dbase16])
;"xx")

None of them worked.

[Ashish_Mathur · Accepted solution]

Hi,

What happens with this

=IF([VALUE]=1;RELATED(Table_01[Dbase17]);RELATED(Table_02[Dbase16]))