Drillthrough ignores ALL filter

[JuliusKairion]

Hey there,

I created a filterpage, where you can set a varity of filters and then do a drillthrough to a reporting page, where you can see the data. On the reporting page are 2 main tables: one shows the actual delivered data and one the planed delivery. For the planed delivery to show all data here I need the table to ignore 2 of the drillthrough filters. Until now it always worked fine by using the ALL filter. But today I noticed, that this isn't working anymore. The drillthrough overwrights the ALL filter... Is this new?

And does anybody have an idea how to do it now? So how I can make some columns ignore specific filters from the drillthrough?

Thanks in advance! 🙂

[v-luwang-msft · Accepted solution]

Hi @JuliusKairion ,

You could learn about the below dax,and test it:

keepfilter

Removefilters

And if still not work ,could you pls share your pbix file ,and remember to remove confidential data.

Best Regards

Lucien

[JuliusKairion]

Hey Lucien,

thanks for the hint! REMOVEFILTERS worked! 🙂

Greetings

Julius