How to do it...

To implement this recipe, observe the following steps:

1. Create the following tables:

R09_ItemDistinct = DISTINCT('R09_Items'[Item])

R09_ItemValues = VALUES('R09_Items'[Item])

2. Create a relationship between the Item columns in the R09_Items and R09_ItemDistinct tables. The creation of the relationship is successful.
3. Attempt to create a relationship between the Item columns in the R09_Items and R09_ItemValues tables. The creation of the relationship results in an error stating that a circular dependency has been detected.