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.