Forum Discussion
Dynamically change a column in a measure
hi !
I have a table with 3 columns: Date, Sales and Cost.
I need to create the measures for sales and cost. in fact, too many of them.
My question is possible to dynamically change a column in a measure, like using the column name as parameter? For example:
Var ColumnSelected = SELECTEDVALUE(column) #Selection from a slicer using a table with rows with the same name of the columns in the fact table
Return
Sum(FactTable[ColumnSelected])
I checked some alternatives but all of them requires to create all the measures of each column and them use SWITCH.
Thank you
You'll need to use the SWITCH approach with a disconnected table, or a better way is to use a calculation group.
Pat
4 Replies
- mahoneypat
Microsoft Employee
You'll need to use the SWITCH approach with a disconnected table, or a better way is to use a calculation group.
Pat- Mp1977
Helper II
Thank you very much.
Switch requeires to create all the measures.
I will check the calclation group .- AnonymousNot applicable
Hey, did you find a solution. Did it work?
- v-luwang-msft
Community Support
Hi Mp1977 ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien