Forum Discussion

skiier1234's avatar
skiier1234
New Member
2 years ago
Solved

Filter context needed for drill through

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)?

1 Reply