Drillthrough with Measures not working

[pbi1908]

Hello all, 

I have a matrix which in rows I have the transaction and in columns  I have the categories (Sales, Purchases, Costs etc.)

I created a drilthrough and when I cilick to the Costs for example is navigating me to the costs of the specific transaction. 

The problem is that I need to remove the column categories and add specific measure for the sales, purchase and costs because I want to add also other KPIs in my matrix. Now if I click to the Costs is navigating me in the lines of whole transactions is there a way to do this ?

Thank you.

I am adding also the link of the pbix with the example in the first 2 pages is the case that I have and is working and in the other is the one that is not working. 

https://drive.google.com/file/d/1RI71p2-mXmuc022UhEa7dSGvP7VJ8Xbo/view?usp=sharing

[Anonymous · Accepted solution]

Hi @pbi1908 ,

In Power BI, drill through works based on the screening context.
Let's take -1096 as an example. When you are using a column in the table, your drill through for -1096 is equivalent to a drill through for Category = Purchase (the filter context on the row) and Delivery = 1 && Stage = Stage 1 (the filter context on the column).

Its corresponding value is only this one, so he will only show this one value.

When you are using a measure, you are doing a drill through on the -1096 because the measure is not a column but a metric, so the drill through is missing the filtering context on the columns, and there is only one condition Delivery = 1 && Stage = Stage 1 (the filtering context on the rows) so it will return all the values that satisfy the condition.

This is by design, and in my testing there is no way to change your measurements to achieve your desired results.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.