Drill through in measures not working

[cottrera]

Hi 

I have a table with various measures in it. Below is an example of three of the measures

Asbestos Survey Logged =

CALCULATE([WP Logged] , WorkPackage[Repair Type] ="Com Asbestos Survey")

Asbestos Survey Completed =

CALCULATE([Jobs Completed] , WorkPackage[Repair Type] ="Com Asbestos Survey")

Asbestos Surveys Awaiting Scheduling =

CALCULATE([Asbestos Survey Logged] , WorkPackage[WP Status] ="Entered Not Issued"||  WorkPackage[WP Status] ="Not Booked")

I have set up a drill through page and added the three measures to the 'Drill through from' area of this page

The table  visual I have built in the drill though page is made up from fields that can be found in the table from which the three measures are calcualting from.

However when  I drill through from the original page NO filters are being applied. Does anyone know what I am doing wrong

Richard

[cottrera]

Hi thank you for your quick response. Unfortuantly this did not work for my report. The page from which I am trying to drill from is total made up from measures

[Anonymous]

Hi @cottrera 

I did the following test for your reference, which is based on the country selected by Page1 drill through to Page2 and then calculate the SUM value of the selected country. I did not put the measure into “Drill through from”, I put the filter fields used in the measure.

Measure:

Sum = CALCULATE(SUM(financials[ Sales]), ALLEXCEPT(financials, financials[Country]))

Output:

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.