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 R09_Table with the following data:

ID	DimKey1	DimKey2	DimKey3	DimKey4
1	blue	red	green	green
2	blue	blue	red	blue
3	blue	red	blue	blue
4	green	green	red	green
5	green	green	blue	green
6	red	red	red	red
7	blue	blue	blue	blue
8	green	green	green	green
9	blue	green	red	green
10	blue	red	green	green

The R09_Table table represents a list of items (ID) with various attributes (DimKey1, DimKey2, DimKey3, DimKey4). In this recipe, we only care about distinct combinations of DimKey1, DimKey2, and DimKey3.