Forum Discussion
Helper IIPower BI Relationship?
Hello:
i have 2 tables where i am not able to create one to many or many to one relationship and getting following message "The cardinality you selected is not valid for this relationship".
Default it is creating Many-to-Many and this not helping me.
I am aware of duplicates & uniqueness that matters in creating relationship.
I have tried creating like 3rd table and couple of others suggestion doing google but no luck.
I am looking for any proven workaround to create one to many or many to one relationship.
Any help is greatly appreciated.
Thanking in advance.
8 Replies
- bikram_laishram
Helper I
I faced a similiar issue. Here's how I fixed it.
I used the table funtion to create a new table
Use the below to create unique ID
Table = DISTINCT(tablename[columnname])
Use this table as a junction table to connect both tables. Change the cardinality based on your report requriements
aaditya2000Hello:
the problem is that i have dependency on 2 columns on my main table and one of column as repeated customer id. I cannot create table with distinct values as columns is one to many values in my orginal table.
thanks for your reply.
- aaditya2000
As you can see from below that because of non-uniqueness values of Table ABC & XYZ, one to many or many to one relationship cannot be created. Many to Many doesn’t helps as it give me cross join. i want to see if there is work around that i can create one to many or many to one. Based on relationship between product_type_no & product_no, i want to display description in my report.
Any help is greatly appreciated.
