Drillthrough keep some filters

[Mahmed1]

Hi - what is the best way to use the drill through feature but only keep some filters?

So i have a measure that just gets handled

Handled = sum(tbl[handled])

This is then places in a visual which is split by product code. I have slicers on the page that has area

When i drill through, i want to be able to keep all the filters but only exclude the calender[date] from the visual i want the chart to show all dates

How can i achieve this?

[Mahmed1]

Hi all

i guess this is not possible. Having no luck with this. Can anyone please advise if this if thin isn't possible 

would really appreciate it

thank you

[Mahmed1]

Any luck please anyone?

[Anonymous]

Hi @Mahmed1 ,

Here I suggest you to try to create a new measure to remove the filter from 'Calendar'[Date] column.

tbl:

Product:

Data model:

Measure:

Handled remove date filter = CALCULATE([Handled],REMOVEFILTERS('Calendar'[Date]))

Result is as below. Here I drill through from Page1 to Page 2. Turn on "Keep all filters" in Page2.

Page1:

Page2:

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.

[Mahmed1]

Hiya

any chance you could help with the above - i hope i was clear in my explanation 

apologies if I aint 

[Mahmed1]

Hey thank you for responding back to me. In your example i dont need the total but to remove the date filter so i can see the values by each date but keeping the filter on the area..shown in example below

[Mahmed1]

Hey any luck on this please

[Mahmed1]

Hey

How long do i give before i bump a thread?

please let me know if im not posting in the right way to get help 

thank you