Getting ready

To prepare for this recipe, do the following:

1. Open Power BI Desktop.
2. Use an Enter Data query to create a table called R02_Table that contains the following data:

Department	Category	ProductID
Sports	AA	1
Education	BB	2
Health	AB	3
Sports	AA	4
Health	BB	5

3. Create the following table called R02_Categories:

R02_Categories = DISTINCT('R02_Table'[Category])

4. Create a relationship between the Category column in the R02_Categories table and the Category column in the R02_Table table. Ensure that Cross filter direction is set to Single.