Include filter context in Drillthrough or implement a concept like Detail Row Expression

The power of DAX to build measures which are natural and intuitive to use in report building is greatly limited by the lack of "filter context" on a drillthrough. Example:



In sales or financial analysis a period comparison with prior periods is very normal.  Let's say I have 3 measures represent Current YTD Sales, Last Year YTD, and 2 Years Prior YTD. I then build a Sales by Customer report (matrix visual) using these 3 measures and the customer account as the row context. To allow the user to drillthrough to the invoice detail making up a YTD value I add an Invoice Details Report (table visual) which acts as a drillthrough "target" for first report.  If I drill through on one of the measures for a specific customer, let's say 1 year prior YTD sales for customer A, the drillthrough target will be filtered for Customer A (row context) but not for the time period which is filter context.



There seem to be no elegant work around for this basic concept. The ability to apply measures filter context to a target drillthrough visual or allow a defined result set like Detail Row Expression in SSAS Tabular would be very helpful in many situations.