Forum Discussion
Self referencing tables
Hi Team
I've got a Table that references itself:
Referrer
-ContactID
-ParentContactID
-...
Patient
-PatientID
-ReferrerID(ContactID)
-...
The parent contact can be a department, an organisation or a team leader and can have multiple layers.
I'm trying to create a slicer or table that shows the individual referrer but also the organisation.
e.g.: Organisation A has Staff Member B and Staff Member C.
If I look at Organisation A I want to be able to see Staff Member B and Staff Member C's information and linked tables. Like the total amout of referrals for Organisation A.
I don't seem to be able to create a relationship between the two attributes of the same table. What would be the best way to achieve above task?
Thank you for your help
Daniel
2 Replies
- AnonymousNot applicable
Hi Daniel_LP
Can you upload sampledata, pbix to Google / OneDrive and share the link here to find a solution.
Cheers
CheenuSing
- Greg_DecklerCommunity Champion
Perhaps just duplicate your query so that you have two identical tables.