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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
awg201
Frequent Visitor

Help with linking related cases table to main case table

Hello 😊

I'm stuck with a specific requirement to be able to show the related cases when a case is filtered. There are two tables:

 

tblCase - which stores all unique Case IDs:

CaseIDNameGender
AAlfredMale
BBenMale
CCharlieMale
DDanielleFemale
EEatonMale
FFredMale
GGregMale

 

tblCaseLink - which has a Link ID 

CaseIDLinkID
A1
B1
C1
D2
E2
F3
G3

 

A relationship by Case ID would be one to one, but the problem is when I filter for CaseID "A", it will only show me that case, instead of the Case "B" and "C", which are related by the LinkID.

 

I tried to merge the LinkID to tblCase, but when I try to get details from the related cases in would just repeat the values from the filtered case. For exmaple, if i filtered for case "A", and I want to get the Name column, case "B" and "C" will just show "Alfred" from case "A" instead of the correct related case names.

 

Ideally, the below would be the desired result if it were a table visual:

 

> Applied slicer: Case ID = "A" 

Title: Related Cases
Case IDNameGender
BBenMale
CCharlieMale

 

Would anyone be able to share their knwoeldge on this (so I can get some sleep) 😔

6 REPLIES 6
v-kathullac
Community Support
Community Support

Hi @awg201  ,

 

we wanted to kindly follow up to check if the solution provided by the superuser resolved your issue? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

v-kathullac
Community Support
Community Support

Hi @awg201  ,

 

we wanted to kindly follow up to check if the solution provided by the superuser resolved your issue? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

Chaithanya.

awg201
Frequent Visitor

Thanks Ashish!


I have studied and applied your logic from your file. I never thought it would be this complex! (for me atleast).

 

The measures work for showing attributes from the case link table, but in my situation, the case link table only has two columns - CaseID and LinkID. All my attribute values are stored in the case table, with other dimension tables connected to it. How would I be able to access those values to display?

 

 

You are welcome.  Cannot understand what you are trying to say.  When you apply my solutin to your data, clearly show the problem that you are facing.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Thanks Ashish,

 

In your example, the details of the case is stored in the link table, which can be retrieved with measures as you have.

 

But in my situation, the details are from tblCase, with many dimension tables connected to it. When I add these details such as age, location etc, it is just repeating values from the sliced case ID.

 

Essentially, if I slice case ID "A" from in tblCase I should see the following related results:

CaseIDNameGenderAge
AAlfredMale23
BBenMale12
CCharlieMale55

 

I've attached a very small example of a dummy dataset and the same logic applied from your attached solution: linked_cases_help.pbix

 

Hopefully it makes sense...appreciate your assistance!!

Ashish_Mathur
Super User
Super User

Hi,

I have solved a similar question in the attached file.

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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