Drillthrough on Measure not working

[nunnc01]

Hi,

I am trying to build a report that shows the performance of a KPI with the ability to drillthough to the underlying person level data.

I have 3 measures built that are working as expected:

KPI 03 - Denominator = count('KPI XX - CF ASSESS CHILD SEEN'[Person ID])

KPI 03 - Numerator = CALCULATE([1 KPI 03 - Denominator], filter('KPI XX - CF ASSESS CHILD SEEN','KPI XX - CF ASSESS CHILD SEEN'[Was the Child/Young Person seen during this assessment] = "Yes")) 

KPI 03 - Result = divide([KPI 03 - Numerator],[KPI 03 - Denominator])

I can display these on my report and they work fine, however I want the ability to drillthrough on the Numerator and Denominator measures so that the user can see which people the numbers relate to.

I have built the page with the person details and added the numerator measure as a drillthrough option but when I actually then drillthrough it is not resticting my records to only show the ones from this measure - it is showing all records.

Any ideas?

[parry2k]

@nunnc01 on drill thru page, did you turned on Keep All Filters option?

[nunnc01]

Yes, it appears to default to on and then gets greyed out when a measure is added.