drillthrough is not working with measure filters

[rajanimaddala]

Hi

I have a table visual with multiple measures(as columns). Each measure is having different filters.

I have created details page to show the report

When I click a measure and drillthrough, measure filter is not applying in the detail page.

How can I make it to pass measure filters?

And is it possible to disable drillthough to particular measure in the table and enable for the rest?

Cheers

[v-diye-msft · Accepted solution]

Hi @rajanimaddala 

Please kindly refer to the similar solved post:

https://community.powerbi.com/t5/Desktop/Drill-Through-Doesn-t-Pass-Measure-Filters-Workaround/td-p/...

When using drillthrough, filters created within a measure with CALCULATE are not passed to the drillthrough page.

Only filters from the report itself can be passed, i.e. fields in the visual itself, slicers, other filters.

This post discusses the same issue and proposes a solution by using a measure on the drillthrough page that replicates the filter on the original visual.