Model Showing Many-to-Many connection when dimensional table is unique

[Mubar]

Hello,

I have a data model with a fact table and 7-dimensional tables. The DimProducts contain unique values of each product name and the fact table contains multiple values.

When I create relationship between DimProduct & Sales using productID it shows many-to-many instead of 1:*/*:1 (and I'm confused). I don't have any missing or blank values in both tables.

Please how can I solve this? Thank you.

[Idrissshatila · Accepted solution]

Hello @Mubar ,

This indicates that there is duplicate in the  dim product table with the Product ID column.

make sure to have a unique value in the dimension table.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Mubar]

Thank you @idrisshatila

[johnt75]

Create a measure as COUNTROWS( DimProducts ) and put that in a table visual with DimProducts[ProductID], sorted by the number of products descending. That will tell you if you have any duplicate values in the products table.