Forum Discussion
nunnc01
Helper II
Helper IIDrillthrough on Measure not working
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?
