Dynamically change a column in a measure

[Mp1977]

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

[v-luwang-msft]

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

[mahoneypat · Accepted solution]

You'll need to use the SWITCH approach with a disconnected table, or a better way is to use a calculation group.

Pat

[Mp1977]

Thank you very much.

Switch requeires to create all the measures.

I will check the calclation group .

[Anonymous]

Hey, did you find a solution. Did it work?