Forum Discussion
Switch Columns Based on Filter
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 ...
- 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])
)
Greg_Deckler
Community Champion
Community ChampionYou 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])
)
Measure =
SWITCH( SELECTEDVALUE('Table1'[Column]),
"Selection 1", SUM([Selection 1]),
"Selection 2", SUM([Selection 2]),
"Selection 3", SUM([Selection 3])
)
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.