Forum Discussion
Append Columns to a Matrix based on Measure Selection
I am curious if I would be able to have a table that only shows the columns if they are selected from a list of possible measurements.
I would create a table that shows the names of all the measures that would be possible to append to the table, and then I would create a slicer containing these measures. When a measure is selected in the slicer, it would append that selcted measure into the table and actually calculate it.
So for example if I wanted to see the total sales for each state, my table would already have the state names as the row as default, but the only way to display the column "sales" would be to select the measure "sales" from the slicer list of measure.
Would this be possible? Any help is appreciated, thanks!
1 Reply
- v-cherch-msftMicrosoft Employee
Hi Anonymous
You may try to use SWITCH Function (DAX). Here is the reference for you.
Regards,
Cherie