Drillthrough Remaining (Other) on a Top N table

[TariqArnabi]

I'm attempting to drillthrough my TopN customer table, the drillthrough is working for the Top N, but is it possible to also have the 'Remaining' drillthrough? 

I've created an inactive relationship between Customer table and ctCustomers by the column description

and utilizing this measure to use on the drillthrough table; 

Sales Measure =
CALCULATE (
SUM ( Sales[Sales] );
USERELATIONSHIP ( ctCustomers[Customer Description]; Customers[Customer Description] )
)

https://drive.google.com/file/d/1rvwOEmeXnPpXAI9GAE4i1lUkV8cRcYVF/view?usp=sharing

[v-yanjiang-msft · Accepted solution]

Hi @TariqArnabi ,

According to your description, I download your sample, as the Sales Measure results in a blank value on the Remaining row, so the Remaining row doesn't show. 

In the Drill Through page, turn on the Show items with no data option, it works fine.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.