Forum Discussion
Drill through on one visual
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.
Super UserThis 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.