Create a dynamic column based on slicer selection

[powerbi_user1]

I have two tables:

Table 1

ColumnA	ColumnB
A1	B1
A2	B2
A3	B3

Table 2

Column Types

ColumnA

ColumnB

I have a slicer for Columns Types and based on selection from that filter a ColumnC should be created in the table - Table1.

Eg., If i select ColumnA in the filter, my Table1 should look like this:

New Table1

ColumnA	ColumnB	ColumnC
A1	B1	A1
A2	B2	A2
A3	B3	A3

If i select ColumnB in the filter, my Table1 should look like this:

New Table1

ColumnA	ColumnB	ColumnC
A1	B1	B1
A2	B2	B2
A3	B3	B3

The final goal is to create a slicer with ColumnC as well and it will show values based on selected value in Column Types slicer.

[v-yuezhe-msft]

@powerbi_user1,

A bit change to Greg_Deckler's DAX.

ColumnC Measure = 
SWITCH(
     MAX('Table 2'[Column Types]),
     "ColumnA",MAX('Table 1'[ColumnA]),
     "ColumnB",MAX('Table 1'[ColumnB]),
     BLANK()
)

Regards,
Lydia

[Greg_Deckler]

ColumnC Measure = 
SWITCH(
     MAX('Table 2'[Column Types])),
     "ColumnA",MAX('Table 1'[ColumnA]),
     "ColumnB",MAX('Table 1'[ColumnB]),
     BLANK()
)

[powerbi_user1]

@Greg_Deckler

Thanks for your reply Greg. But I want to use ColumnC as a slicer anda measure cant be used as a slicer.

Also, using column C as an independent column shows only the maximum value for the column selected in the slicer. 

[Greg_Deckler]

Columns cannot be dynamic based upon user selection. Just use the disconnected table trick to use your measure as a slicer.

[Anonymous]

What is "the disconnected table trick"?