Hey Melissa, I have attached a workbook with what I believe to be the solution you are looking for. Here's how to replicate it:
1. Edit the Set 1 and Set 2 calculated fields so that they end with ELSE "NULL " (note that the space before closing the quote is intentional)
2. Create a new calculated field (I called it Combo) that is simply [Set 1]+[Set 2]
3. Create a String parameter (I called it Select Set) with 3 values. The first value is simply a space, which is displayed as All, and the other two values are SET 1 and SET 2. Right-click the parameter and select "Show Parameter Control." I also like to format the parameter as a single value list.
4. Create a new calculated field (I called it Filter) whose syntax is
IF CONTAINS([Combo], [Select Set])
5. Drag this field to the Filter card and filter on "Show"
Now, when you select a value in the parameter control, the Filter calculated field will only show rows whose Combo value contains the selected string. Since all values contain a space somewhere in them, that is why the "All" parameter value is only a space. Let me know if this works for you.
Book2.twbx 27.9 KB
Thank you very much! I had been struggling with this for a while.