I am trying to create a filter using the measure names but not show all of the options. I only want to show 4 items out of 50.
I created a parameter called "Select a Measure1", then I'm trying to create a calculated field:
Case [Select a Measure1]
When "# Of Work Orders" Then [# of Work Orders]
When "Open Work Orders" Then [Open Work Orders]
When "Work Orders Completed" Then [Work Orders Completed]
When "# Completed on Time" Then [# Completed On Time]
When "# Completed Overdue" Then [# Completed Overdue]
END
But I'm getting cannot mix aggregate and non-aggregate comparison in results or comparisons in "Case" expressions. What is the best way to limit the measure names options showing in the filter?
