Filter table based on another table's values

[anewsom]

I have a table on PowerBI, called records.

I have a second table called questions in a many-to-1 relationship with records; AKA each record has many questions. Question have a "question", "answer", and recordID columns.

I want to make a fitler which filters the records based on the question and answer columns.

So if I have a question of "Color" (among many other questions) i can say "give me records with a question called 'Color' with an answer called 'Red'"

Is there a way to do this with a filter or will I need to make a new column each time?

[V-pazhen-msft · Accepted solution]

@anewsom 

You should have a table visual includes all the column you want to show. Once the relationship between the tables is managed correctly, you could filter the 2 columns using the filter panel or create 2 slicers using Question and Answer column. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Let your data model do the work. Make sure the filter direction is set up in a way that your question can be answered. You need a bidirectional filter as you want to filter from the many side to the one side.