Forum Discussion
Solved
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 th...
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
rubayatyasmin
Community Champion
Community ChampionHi, 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