Forum Discussion
How to relate multiple columns from one table to the same column in another table?
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?
Hi abrahamfariaz ,
You can refer the following links to get it:
Using USERELATIONSHIP function:
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
3 Replies
rubayatyasminCommunity Champion
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
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!
Hi abrahamfariaz ,
You can refer the following links to get it:
Using USERELATIONSHIP function:
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
