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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Daniel_LP
Frequent Visitor

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 2
Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
CheenuSing
Community Champion
Community Champion

Hi @Daniel_LP 

 

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

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.