Passing calculate filter to drillthrough

PowerBITestingG · ‎06-09-2022

Anybody knows an actuall workaround or trick to enable this function?

Been looking through the forum but havent found a good answer

Thanks!

mdHuz · ‎10-13-2024

Has any solution being found for this scenario?

KNP · ‎06-09-2022

What is the user experience? Drilling through from what types of visual?

With the keep all filters, most drill through scenarios work. The extra detail was useful, but need more.

I agree with @TomMartens, based on the info given, seems unlikely, but I'm curious to hear the use case and more detail.

For now, I need to get back to my day job.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr

Proud to be a Super User!

hstance · ‎07-14-2022

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

greys out keep filters = product limitation.

hstance · ‎07-14-2022

That does not work.

KNP · ‎06-09-2022

Hi @PowerBITestingG,

I'm not sure anyone can help you with the detail you've provided.

As @Pragati11 was kindly trying to point out, if you take the time to provide some context, then you will likely get an answer to your question.

Don't mistake a request for more detail as an inability to understand or answer the question. She is more than qualified to help you.

Thanks.

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr

Proud to be a Super User!

PowerBITestingG · ‎06-09-2022

Ill try to break it down

I have a measure using Calculate and I want to pass that filter to a drillthrough page

Like Measure = calculate([amount], Location[Country]="USA")

I want to pass Country = USA to the drillthrough page

hstance · ‎07-14-2022

I have the same problem. Filters within a Calculate statement are not passed to the drill through visual. Your problem is clearly stated and the folks not able to understand are simply not reading. I think this is a product limitation myself.

TomMartens · ‎06-09-2022

Hey @PowerBITestingG ,

at 1st glance you can't.

If you take the time and create pbix file containing sample data, but still is reflecting your data model (tables, relationships, calculated columns, and measures), maybe one of the members of this community will spend some time to think more thoroughly about your requirement: passing a filter condition to a drillthrough page.

Regards,

Tom

Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany