Forum Discussion

HenryJS's avatar
HenryJS
Icon for Post Prodigy rankPost Prodigy
6 years ago
Solved

Measures in a dropdown

Hi all,

 

Is it possible to have a drop down which selects measures?

 

Thanks,

 

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi HenryJS ,

     

    Please check the following steps.

    1# Create a table with a column include the measure's names.

    2# Create a meaure like:

     

    Measure = SWITCH(SELECTEDVALUE('Table'[measure]),"avg",[avg],"sum",[sum],"please select a measure")

     

    Result would be shown as below.

     

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi HenryJS ,

     

    Please check the following steps.

    1# Create a table with a column include the measure's names.

    2# Create a meaure like:

     

    Measure = SWITCH(SELECTEDVALUE('Table'[measure]),"avg",[avg],"sum",[sum],"please select a measure")

     

    Result would be shown as below.

     

     

    Best Regards,

    Jay

    Community Support Team _ Jay Wang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Calculate(Sum($$$$),Filter([Table],[Table].[Column] = SelectedvalueMeasureyoucreated)