Forum Discussion

Uli_from_German's avatar
Uli_from_German
New Member
9 years ago

Relationships and modelling data

I have a problem with modelling Data-tables : Table One :   Buildings (Definition of houses)                        Column :  Building_ID  120                                        Building_ID  1...
v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
9 years ago

Uli_from_German

 

In PBI, we cannot have two active relationships between two tables. We can define the relationship as below so that there will be only one active relationship between two tables.

You can take a look at this official document to understand more about the relationship in Power BI.

 

If you want to have two relationships between two tables, you can inactive one of the relationship as below. And use USERELATIONSHIP Function (DAX) to specify the relationship to be used in a specific calculation when you need it.

 

Best Regards,

Herbert