Switch Columns Based on Filter

[Anonymous]

I would like to create a filter than changes which column is referenced based on selection.

For example:  I have a filter with (Selection 1, Selection 2, Selection 3)

When I choose Selection 1 I get:

Main	Selection 1
A	5
B	4
C	2
D	5
E	4
F	2

Source Table

Main	Selection 1	Selection 2	Selection 3
A	5	2	3
B	4	2	6
C	2	2	4
D	5	2	3
E	4	2	2
F	2	2	2

[Greg_Deckler · Accepted solution]

You could do that along the lines of:

Measure =
SWITCH( SELECTEDVALUE('Table1'[Column]),
"Selection 1", SUM([Selection 1]),
"Selection 2", SUM([Selection 2]),
"Selection 3", SUM([Selection 3])
)

[Anonymous]

Excellent that worked.

Now what if I want the column name to also update based on the selection?  With that formula my column header is always Measure.

[Greg_Deckler]

I am not aware of any way to do that, attached is the closest I can come.