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 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 |
- 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])
)
3 Replies
- 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])
)I am not aware of any way to do that, attached is the closest I can come.