several relations between two tables

[Anonymous]

hello

i have two tables, with same Attributs and name of Reference.

The first table is my measure table, and the second one is my specification table.

I want to filter my specification table thanks to my measure table, with two filter/segment : the Attributs and the Reference.

But it is forbidden :

How can i fix it ?

thanks a lot

[AlexisOlson · Accepted solution]

A relationship can only be created between single columns, so if you need a relationship on multiple columns, then you need a combined column or index to match on. This isn't often a great idea though.

A better solution is to create a proper star schema with dimension table(s) for these columns.

[Anonymous]

thank you !!

i find that create a new column with a combination of two name in each table, was for me the easier and faster solution. it works well, because i need so a single relationship on this "index false name filter".

i will examine the star schema when i will have time 😉

[mahoneypat]

Only one relationship can be active at a time, so you need to use USERELATIONSHIP to activate the inactive/dotted one in your measure(s).

Using USERELATIONSHIP in DAX - SQLBI

Pat