Advanced Filtering Help

[Chris_CF]

Hi,

I have an Explore that links "Student" records with N-number of "Questions" records and associated "Question Answers" records. In the Explore, I can view each student's answer to the different questions by using the "Name Label" field on the Question as a pivot and then I have a measure that I've defined for the Question Answer that gives me the answer value.

Here's an example of what the results look like in the Explore:

What I'm trying to do is create a filter that returns all the student records where they, for example, answered "Yes" to one question AND "Current Student" to the other question.

When I try to do this in the Explore I run into the following limitation:

Is there a good way to do what I'm trying to do?

Any questions, insights, or thoughts are very welcome!

Thanks,

Chris