Column Item no in Table Product contains a duplicate value '100-Product1'

[bzeeblitz]

Product

Itemno productdetails

Order

Itemno orderdetails

When I create manage relationship from product Itemno->Order Itemno  ,

cardinality-one to many,cross filter direction-single

Error details

Im facing error this relationship has cardinality on-many .This should only be used if it is expected that neither column(item number and Item#)contains unique values and that the significantly different behaviour of one-many relationship is understood.

[Kedar_Pande · Accepted solution]

@bzeeblitz 

1. In your Product table, make sure Itemno contains only unique values. If not, consider creating a calculated table or removing duplicates.
2. If both tables contain duplicates in Itemno, consider changing the relationship type to Many-to-Many. This is often necessary if both tables have repeated values in the Itemno column.
3. If both columns have non-unique values, you can introduce a bridge table that holds unique Itemno values, linking the two tables via this bridge.

💌 If this helped, a Kudos 👍 or Solution mark ✅ would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn

[bzeeblitz]

Thanks a lot for your inputs

Could you please show and tell with some sample example for my usecase?also im very new to BI reports

Thanks in advance