Forum Discussion
Helper IIDrill through with measures
Hi everyone!
I have a matrix with three measures(Private, Public, Total).
Now, I want to use "drill through" with these measures. For example, I clicked "1545" and it will return a result whose region is North and "Public/Private" is "Private".
How to use measure to pass a parameter?
Thank you in advance!
Hi misaki233 ，
Check the similar thread below:
https://community.powerbi.com/t5/Desktop/Drill-through-for-calculated-measure/m-p/1086091
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
5 Replies
v-kelly-msftCommunity Support
Hi misaki233 ，
Check the similar thread below:
https://community.powerbi.com/t5/Desktop/Drill-through-for-calculated-measure/m-p/1086091
Best Regards,
KellyDid I answer your question? Mark my post as a solution!- misaki233
- AllisonKennedy
Community Champion
I would suggest adding [Region] to the 'Add drillthrough fields here' box and then making sure to 'keep all filters' as turned 'on'. The Keep All Filters will bring through the private part of the selection, and the adding region to the field list will take care of the rest. 🙂 - amitchandak
Super User
misaki233 , the measure can not pass parameter. Parameter need to there is the passing visual should be added part drill "Add drill Through filter here"
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough
theovAdvocate III
Check this out to fix issues when drilling through a measure:
