Ignore specific filter during drill through

[austinhammer]

Hello,

I have a dataset that queries daily and amends today's records onto yesterday's records.  Columns include the QueryDate and the Key which identifies the record.  The idea is to identify changes in the data from day-to-day.  My matrix is filtered to show the Top 1 QueryDate, ie "current" data.   I'd like to be able to drill down on that matrix and have the secondary table display all records of that Key, meaning it would show each QueryDate and allow me to see changes day-to-day.  

Since I am filtering the Matrix by Top 1 QueryDate, the secondary table also keeps that filter and will only show the Top 1 QueryDate.  I know that I can achieve this using Rank and measures in my matrix instead of the raw data fields, but I'm wondering if there is an easier way to prevent the drill through from keeping the Top 1 QueryDate filter.  

No selections. Matrix filtered to Top 1 QueryDate. Bottom table showing all records

Single Key selected. Top 1 Filter applies to bottom table so only 1 record is displayed - not my goal

Top 1 Filter removed from Matrix. Single Key selected. Records in bottom table are displaying all QueryDates which is how I want

[Anonymous]

Hi @austinhammer ,

As far as I know, if you want to remove the filter from [QueryDate] column when using drill through function. I suggest you to add a filter like REMOVEFILTER() in the measure in matrix visual. Or you need to remove the filter in filter field manually when you using drill through.

Best Regards,
Rico Zhou

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