DRILLTHROUGH Function - Filters in Calculation Pass To Drill Through

[David_Pidgen]

I would like to have a Drill Through function that activates filters on a measure so that they pass through to the drill through.

Below I have added an example measure to demonstrate how this could work, everything within the DRILLTHROUGH Brackets becomes active when you drill through.

CALCULATE ( COUNTROWS (Table1),

                            DRILLTHROUGH(

                               Table1[Column1] = “Filter”,

                                        Table1[Column2] = “Filter”,

                                              USERELATIONSHIP(Date[Datekey],Table1[Orderdatekey]

                                                          )

                       )

Currently if I were to drill through on the measure above you would go through to the table1 minus the filters from the measure and the date would be driven by the active date relationship rather than the one I have selected. To get around this you would have to filter the visualisation but if you have a table with multiple measures in this would not work.