Forum Discussion
Measures in a dropdown
Hi all,
Is it possible to have a drop down which selects measures?
Thanks,
- Anonymous6 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
- AnonymousNot 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.
- AnonymousNot applicable
Calculate(Sum($$$$),Filter([Table],[Table].[Column] = SelectedvalueMeasureyoucreated)