Drill through with measures

[misaki233]

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!

[v-kelly-msft · Accepted solution]

Hi @misaki233 ，

Check the similar thread below:

https://community.powerbi.com/t5/Desktop/Drill-through-for-calculated-measure/m-p/1086091

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[misaki233]

Thanks for all your replies!

@v-kelly-msft 

This seems to be the result I want, I will test it later. 

[AllisonKennedy]

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]

@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