Forum Discussion

Daniel_LP's avatar
Daniel_LP
Frequent Visitor
7 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Daniel_LP 

     

    Can you upload sampledata, pbix to Google / OneDrive and share the link here to find a solution.

     

    Cheers

     

    CheenuSing

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Perhaps just duplicate your query so that you have two identical tables.