Measures in a dropdown

[HenryJS]

Hi all,

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

Thanks,

[Anonymous]

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

[v-jayw-msft · Accepted solution]

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.

[amitchandak]

Refer :https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...