Not certain what your goal is but see the attached
the union created nulls so I changed the formula slightly
then added only one HC filter to context
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Test workbook (1)_v10.2.twbx 22.2 KB
Thanks for looking into it. Actually HC type has to be quick filter and null should not be displayed in the drop down. When we select values that should be applicable to Staff Data set type but not seating.