Thank you for your response. Method 2 in the workbook from that thread was very close to what I was searching for. I got that to work with my data with one small issue.
When you show the quick filter Sub-Category and choose (All), your method 2 returns all Order ID that contain whatever was in "Choose Sub-Category". That's good. However, when I choose (All) for my sub categories, all the sub-categories and all the Order IDs are returned regardless of whatever was in "Choose Sub-Category".
I wish I could show you a workbook but my data contains confidential information. I have one "Choose" parameter, two Dimension (sub-categories and Order ID), one measures (sub-category TC filter), filtered by sub-category dimension and sub-category TC filter. Measure Values not too important because I'm only trying to show all Order IDs that contain the sub-category. If you have any insight, that would be greatly appreciated. Thank you!
There are two ways I can duplicate your behavior - if I set the Compute Using for the Sub-Category TC Filter to Table (Down), or I set the Compute Using to Sub-Category but don't choose any values. The Compute Using needs to be set to Sub-Category, with the filter set to At Least 1.
If this doesn't work, then it's going to be really tough to diagnose without seeing more of how you have the view set up. If you're ok with me alone seeing it then contact me at jonathan.drummey (at) gmail (dot) com and we can set up a webex.
Thank you Jonathan, you got it figured out.
Understanding "Compute using" would make excellent commentary about this problem. Well done.