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