Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
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
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
Proud to be a Super User!
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
84 | |
66 |