PBI creating incorrect relationship

[ryand009]

Hello.

I'm creating a non active relationship from my Canendar table to a date on my Catalog table (see below). Problem is PBI is automatically creating a 1:1, when it s definitely a 1:M relationship. Thre are multiple occurances of the same date in Catalog. Both attributes are Date types, formatted as dd/mm/yyyy

Not sure why this is happening and its producing some odd values in measures?

Any advice, gladly accepted.

Thanks in advanve

Ron

[Greg_Deckler]

@ryand009 Can you just edit the relationship by double-clicking it and change it to 1:M? 

[CoreyP]

This was happening to me just yesterday. I was only using sample data with three rows, but it was because there were not multiple values of the same date in the fact table. When I made two rows have the same date value, it allowed the 1:*. Are you certain your catalog table has multiple of the same date value?