Drill Through Question

[Unknowncharacte]

Hi, 
I created a report with two pages, on the main page, I have a list of cases

When I click on a case, I am taken to another page, with case details, let's take A11 for example:

My issue comes in when a case has more than 1 subject - A13, has 3 subjects. When I click on A13, "Detailed Case View" tab shows information for that specific subject rather than all 3. My initial solve was to concatenate subject names and complaints, so there is only 1 line for A13 but my solution was declined.

The user wants to keep the main page view as is, and when clicking on A13, "Detailed Case View" tab should show all the subjects in the case. Can someone help me achieve this?

Desired Outcome on Detailed Case View when clicking on A13

Sample PBI:

Page Navigation.pbix

[lbendlin · Accepted solution]

You need to use a shadow copy of your table and then use a measure to transfer the partial filter from the drillthrough to the shadow table.

[Unknowncharacte]

Thank you so much!