Issue with relationship between 2 calculated columns

[IvanS]

Dear all,

I am struggling with creation of relationship between 2 calculated columns.

I have 2 tables: 

pbi DIM_EIPA_Connectors (dimension table)

pbi FACT_EIPA_Connectors (fact table)

In both tables I have created unique identifier using calculated columns - the function is using column index to add a suffix in order to ensure that the entries are unique.

Connector_ID =
'pbi DIM_EIPA_Connectors'[data.id]
&
RANKX(
FILTER('pbi DIM_EIPA_Connectors',
'pbi DIM_EIPA_Connectors'[data.id]=EARLIER('pbi DIM_EIPA_Connectors'[data.id])
),
'pbi DIM_EIPA_Connectors'[Index],,ASC)

 

Now, I have removed all relationships that might impact those 2 tables. Then I am trying to create the relationship between those two columns.

 Following is the error - I would expect to have one-to-one relation or (one-to-many/many-to-one) but there is issue with all types of relation incl. many-to-many.

I exported the data into excel to check if there are any duplicates or blank values but there isn't any.

 Any help is much appreciated!

Ivan

[smpa01 · Accepted solution]

@IvanS  if you are absolutely sure that there are only a single instance, then blank values are driving that Cardinality (Many to Many)

[IvanS]

You are right, I oversee the blank entries. 🙂 Thank you for help!

[nj17]

Blank values in dim or fact table?