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 th...
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.
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