Forum Discussion
Model Showing Many-to-Many connection when dimensional table is unique
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.
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 👍
3 Replies
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.
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 👍
Thank you @idrisshatila
