How to relate multiple columns from one table to the same column in another table?

[abrahamfariaz]

I want to relate the columns "ID_Delito Primero," "ID_Delito_Segundo," "ID_Delito_Tercero," "ID_Delito_Cuarto," and "ID_Delito_Quinto" from the "Sentenciado" table with the column "ID_Delito" from the "Delito" table. However, when I try to do this, Power BI only allows one active relationship and deactivates the others. Can you help me?

[abrahamfariaz]

Hi @rubayatyasmin,

Thanks for your answer!

And how can I solve this? Because each "Sentenciado" (defendant) can commit diferent "Delito" (crimes), and more than one at a time.

Thanks in advance!

[Anonymous · Accepted solution]

Hi @abrahamfariaz ,

You can refer the following links to get it:

Using USERELATIONSHIP function:

Inactive relationships

Orders Shipped =
CALCULATE(
    COUNTROWS(Sales)
    ,USERELATIONSHIP('Date'[Date], Sales[ShipDate])
)

UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI - RADACAD

Best Regards

[rubayatyasmin]

Hi, @abrahamfariaz 

Power BI allows only one active relationship with a table, other relations will be deactivated. But if you want to use any deactivated relations you have to use "related" or "relatedtable" DAX function. 

Here is a article with example for you. 

If this post helps, accept this answer as a solution. 

If my assistance helps you in any way, hit  👍. 

Thanks