You can´t create a direct active relationship

[Anonymous]

Hi my friends. 

I'm developing a model to measure HR payments. The model that I want to use is: 

The problem is that I can't create two relationship the first one with the Calendar and the second with the Index, any help ? 

[Anonymous]

Hi @Anonymous ,

Will you consider to create an inactive relationship and use USERELATIONSHIP() function to active it in DAX formula?
If so you could take a look at these blogs.

https://www.sqlbi.com/articles/using-userelationship-in-dax/ 

https://www.sqlbi.com/articles/userelationship-in-calculated-columns/ 

Best Regards,

Jay

[PaulDBrown]

Have you thought about appending the fact tables into 1? 

[amitchandak]

@Anonymous , If you need two columns in relation, You need to concatenate columns and join.

In the above model, one to Many single-direction relations is possible from Date /class to other tables. Bi-directional relation many cause loops here.

[Anonymous]

Hi @amitchandak, thank you for your help. 

It was my mistake there was a relationship 1:1 meanwhile I expected 1 to many, so I changed it. 

Thank you!