Forum Discussion

Mp1977's avatar
Mp1977
Icon for Helper II rankHelper II
4 years ago
Solved

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's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft 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's avatar
      Mp1977
      Icon for Helper II rankHelper II

      Thank you very much.

      Switch requeires to create all the measures.

      I will check the calclation group .


      • Anonymous's avatar
        Anonymous
        Not applicable

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

  • v-luwang-msft's avatar
    v-luwang-msft
    Icon for Community Support rankCommunity 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