Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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! 🙂
Solved! Go to Solution.
Hi @JuliusKairion ,
You could learn about the below dax,and test it:
And if still not work ,could you pls share your pbix file ,and remember to remove confidential data.
Best Regards
Lucien
Hi @JuliusKairion ,
You could learn about the below dax,and test it:
And if still not work ,could you pls share your pbix file ,and remember to remove confidential data.
Best Regards
Lucien
Hey Lucien,
thanks for the hint! REMOVEFILTERS worked! 🙂
Greetings
Julius
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |