How to resolve the loop relationships

[Anonymous]

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.

[Anonymous]

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]

Hi @Anonymous ,

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.