I'm not sure whether I understand your issue. When you say that the calculated field is showing only the first value from the parameter, I think what you're seeing its that parameters are single-select, not multi-select like the multiple value list quick filter that has multiple check boxes. That's why parameters just have sliders, drop-downs, and radio buttons as options.
If you have a field that you want to filter across data sources that gives you a multi-select option, the two choices are a global quick filter (which can be slow in cases) or an action filter based on a worksheet (which can be very fast, but isn't as intuitive to use).
Does that answer your question?
thanks for your response. That is a good point. I'm not sure if I'm even trying for the right solution.
On the screen shot I attached, I am trying to get the school name to be the main global filter choice so when a user picks a school, all other boxes isolate to that particular school or schools.
Then I wanted users to be able to filter by each growth metric (where it says select growth metric) & by subject (where it says "filter by subject") AFTER they had selected 1 or a couple of schools.
When I had a filter established for subject proficiency, I couldn't put the growth metrics in as measures because those metrics would then appear in the filter list for subject proficiency (and vice versa, subjects would appear in growth metrics). I am trying to differentiate the two and haven't been able to do so.
So my workaround was trying to do a parameter/calculated field that I read about...maybe I need to set up an action on the filter? I tried that too, but obviously didn't do it correctly.
Which would you suggest? Thanks for your help.
(screen shot has shots of dropdowns after a set of schools is selected)
filter-screenshot.jpg 1.9 MB