Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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 👍
Proud to be a Super User! | |
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 👍
Proud to be a Super User! | |
Thank you @idrisshatila
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.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
39 | |
27 | |
27 |
User | Count |
---|---|
97 | |
97 | |
58 | |
45 | |
42 |