Filter context needed for drill through

[skiier1234]

Hello!

I have a dataset of accounts and balances that I want to filter to just the newly created accounts within a selected time period. I've accomplished that with DAX for the measures displayed in a table, but when I drill through to the rest of the account details, the filter context in the measure doesn't carry into the drill through.

I'm defining "New accounts" by if they were open between the dates selected.

Here's an example of one of the measures: 

End Date Balance Daily NEW ACCOUNTS =
VAR SelectedStartDate = MIN(_Calendar[Date])
VAR SelectedEndDate = MAX(_Calendar[Date])

RETURN 
CALCULATE( 
SUM('Fact table'[Balance]), 
'Fact table'[Full Date] = SelectedEndDate, 
'Fact table'[Account Open Date] <= SelectedEndDate, 
'Fact table'[Account Open Date] > SelectedStartDate ) 

So my question is: how can I filter the drill through (or the main page and have the drill through keep the page filters)?

[Anonymous · Accepted solution]

Hi @skiier1234 

When using drill through, filters created within a measure with CALCULATE are not passed to the drill through page. Only filters from the report itself can be passed, i.e. fields in the visual itself, slicers, other filters.
In this post proposes a solution by using a measure on the drill through page that replicates the filter on the original visual:
Solved: Drillthrough on measure with dax filter context no... - Microsoft Fabric Community

And about the ‘KEEPFILTERS’ in the DAX, you can refer to this document.
KEEPFILTERS function (DAX) - DAX | Microsoft Learn

Best Regards,

Dino Tao

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