Forum Discussion
several relations between two tables
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
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.
3 Replies
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
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.
