Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Perhaps just duplicate your query so that you have two identical tables.
Hi @Daniel_LP
Can you upload sampledata, pbix to Google / OneDrive and share the link here to find a solution.
Cheers
CheenuSing
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |