I am trying to get drillthrough to work from a TopN and Remaining view (show the top 5 customers and group the rest under "Remaining"). The grouping and reporting is working fine thanks to these posts.
But I cannot get the drillthrough to work. This is because the table that is created to hold the list of things + other is not connected to any of the fact tables. I don't think there is a way to get drillthrough to work with the disconnected table but I wanted to ask.
The linked model has a sales table and the topn table as well as topn customer used in the visuals. It also has a drillthrough page set up for testing.
In DAX there are a lot of little things especially when you are referring to measure that are based on context so just changing a small detail it's enough to make or break a calculation.
On your case what I did was to setup the context of the customer that didn't existed with disconnected tables so not being abnlw to filter from main table to drill through, bu of you had an active relation your Top N would not work.
Workaround is to activate the relationship when you need it so on the detail table using the measure.
Did I answer your question? Mark my post as a solution!