Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ManojRajendran
Frequent Visitor

How to resolve the loop relationships

I have 3 tables Transactions, Party and Party account. Party is connected to Party account by Party_ID, party account is connected to Transactions by Account_Sky to Creditor_Account_ID (active) and Debtor_Account_ID(inactive), Party is connected to Transactions by Creditor_ID(inactive) and Debtor_ID(inactive) respectively. After connecting all these, it forms a loop now. And if i create a tabluar report, it has to show all the details from Transactions, Party and Party account tables respectively. How do i solve this. Please help.Capture.PNG

2 REPLIES 2
ManojRajendran
Frequent Visitor

Hi @MFelix ,

 

PFB the link with PBIX file, Basically I need to Present the transactional details in a report based on all these 3 tables. For example, currently the Debtor id is active between party and transactions, and if i pull in the party name it is nothing but debtor name since debtor id is active, I need to have the creditor name as well in the report but currently creditor id is inactive, so we need to pull the labels based on active and in active relationships. Similarly for Debtor_account_id and Creditor_account_id from Transactions_Party_account table.

Second requirement is ,if we want to slice party table with Transactions_Party_account, it should also work. Just need to show the report having party name and account details. Hope the requirements are clear. Let me know if not. Thanks in advance.

https://drive.google.com/drive/folders/1jr9hBvLOZHLdBqu_6m-st5ktJmFPtbjv?usp=share_link

 

MFelix
Super User
Super User

Hi @ManojRajendran ,

 

This depends on what you want to present but looking at the data you have you must create some measures with the USERELATIONSHIP syntax or some other calculation present.

 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

 

Also if possible can you share the expected result.
If the information is sensitive please share it trough private message.

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.