Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
User | Count |
---|---|
85 | |
79 | |
64 | |
52 | |
46 |
User | Count |
---|---|
101 | |
43 | |
41 | |
39 | |
36 |