Drill-Through Issue Please Help

[Learner27]

Hello, everyone.


I have a table visual where I'm calculating specific totals related to consumers when I drill through from the main page to the drill-through page. I'm encountering a count that differs from the actual count. I have thoroughly checked all the filters, including Keep filters, and confirmed that I'm using related measures for that specific data.

On my main page, there's a single slicer, and when I use the slicer in between, it filters correctly. However, the requirement mandates that I must use the single slicer.

My measures are as follows:

Count = COUNTBLANK(Data_Table[ConsumerName]),
FILTER(ALL(Data_table[Date]), Data_table[Date] <= MAX(Data_table[Date]), ALLSELECTED(Data_table[Date]))

I want to display the count for these particular consumers in the drill-through page, where I automatically get a date filter in the drill-through field. The default date is the selected date on the main page, which, for instance, is set to 10/25/2023 as "Is Date."

I've attempted to adjust the date filter by setting it to the minimum and maximum date values, but when I drill through again, I still encounter the same date filter as "Is Date." If I remove this date filter in the drill-through, I get the actual count.

Please help; it's very urgent, and your assistance would be greatly appreciated.

[Anonymous]

Hi @Learner27 ,

there are a few possible solutions:

You can use a bookmark to reset all the filters that were applied after the drill-through, but keep the filters that were passed by the drill-through. To do this, you need to create a bookmark on the drill-through page without any filters applied, and then add a button that navigates to that bookmark as its action.
You can use a card visual to drill through with multiple selections, instead of a table or a chart. Power BI considers a card to be a single data point, regardless of the number of filters applied to it. If you drill through on the card with multiple data points selected, the drill-through page will have all of the relevant filters applied.
You can use the Keep all filters option to retain all of the applied filters on the drill-through page. To do this, you need to set Keep all filters to On in the Drill through section of the Visualizations pane on the drill-through page.

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

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

[Walter_W2022]

Hi @Learner27 , not sure whether you can make up some data in PBI workbook, then upload here for us to analyse.