Drill through on one visual

[vannavada]

Hi Users, 

I have an issue that I couldnt find solution for. I have a summary page (basically no visuals except a table visual with multiple slicers). From there, I have drill through to a new detail page. But now the new requirement is to have one more detail visual with different columns in the same detail page.

The issue is, this new 2nd detail visual is supposed to show all data for an ID from summary page. For Example, the user has drill through from summary page for ID = 100000 into the detail page, the detail page should show for that row selected but also the new visual is supposed to show all data for ID = 100000. Basically the 2nd visual shouldn't be effected by the drill through but also give all related rows for that ID. 

Anyone has any suggestions. Thanks!

[Tutu_in_YYC · Accepted solution]

This is a silly recommendation that works.. but not a good practice, i consider this as a HACK. Proceed with caution. Assuming you have star schema:

1. Duplicate the dimension/table that is being filtered and still have that connected to the fact table that will be aggregated. The idea is, drillthrough carries over filter context, but only from a certain table/column. If you have a duplicate of the table, it will only filter the first one (lets call it table A), not the duplicate (lets call this table B). 

2. To make it work, your measure must remove filter context from table A, (use DAX function Removefilter). And create that 2nd visual using table B.