Relationship is set, but results don't reflect the relationship

[russellclaude]

I am not new with creating relationships, and I have been using power BI for only about 5 months. But- this error seems like an easy thing to fix, but I cannot figure it out.

I am simply trying to add an item list, by UPC, to my center of the star-schema. Without the item list everything works fine, but when I add the attribute list I get a cartesian-product-type result.

Here's my relationship:

Joined on UPC code

Here's my result in a table Viz with the Cartesian-Product effect:

Cartesian-product results in Table visual. These should all match 1:1 in the view.

What am I missing!?!?!?!?!?

[parry2k · Accepted solution]

@russellclaude becuase your WM UPC is on many side. Add new column in your Item table or change filter direction to both

WM UPC = RELATED( UPCTable[WM UPC])

[v-eachen-msft]

Hi @russellclaude ,

You could accept reply you like if your question has been solved.

[parry2k · Accepted solution]

@russellclaude becuase your WM UPC is on many side. Add new column in your Item table or change filter direction to both

WM UPC = RELATED( UPCTable[WM UPC])

[russellclaude · Accepted solution]

Okay, @parry2k , THANKS for the help!

I updated the relationship to be BOTH, but that did not fix the problem, so I added the column to my table at the center of my Star-Schema as you recommended using RELATED(). That seems to be working. I don't feel it is efficient, but at least it is working! 🙂

Thanks a ton for the help!