Drill Through Challange

[PowerRobots99]

Hello Friends,

Please refer link to the file.  

https://drive.google.com/file/d/1gq5CinlSQu9qnN0aKdq-6cFJkeQrepLk/view?usp=sharing

I am using a matrix visual which has multiple measures, My drill through is not working,

Is there any way to set up drill through accurately so that if i can select the value of any measure in a table visual, i can drill through it to details page.   

[NaveenGandhi · Accepted solution]

@PowerRobots99 

You can drill through the location and date, but not the measures. As power bi can't work out the calculation and drill through according to that.

Here is a workaroud that you can try if it fits your purpose.

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

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

[cpwebb · Accepted solution]

There are only unsatisfactory workarounds in a Power BI report (I blogged about something similar here a few years ago https://blog.crossjoin.co.uk/2018/12/21/power-bi-drillthrough-complex-measures/) but if your users really need access to detailed data, using Analyze in Excel to connect to your Power BI semantic model is a much better solution because drillthrough on PivotTables supports the Details Row Expression, which gives you a lot more control. See https://selfservicebi.co.uk/hidden-features-of-analyze-in-excel-part-1-show-me-the-details/ for a good explanation of how it works.

[NaveenGandhi · Accepted solution]

@PowerRobots99 

You can drill through the location and date, but not the measures. As power bi can't work out the calculation and drill through according to that.

Here is a workaroud that you can try if it fits your purpose.

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

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

[NaveenGandhi]

Hi @PowerRobots99 

Drill through by measure is not possible. You can only achieve it through column fields, In your example location and report date will trough as expected.

If this post helps, then please consider Accept it as the solution to help the others find it more quickly. Appreciate you kudos!!

Follow me on LinkedIn!!!

[PowerRobots99]

Are you sure?,

If we cant drill through, then what is the use of just displaying numbers by using calculated mesures?