Drill Through Doesn't Pass Measure Filters

[udian]

Hi,

I am trying to use drillthrough in my PBI report.

I have the folowing table:

when i press drillthrough on the cell where # PMTs Range 1 = 20 the drillthrough passes the activity category and activity sub category correctly, but it ignores the filter in the measure that filters on Range = 1 and then the drillthrough report brings me results for all 65 payments of category = A and sub category = A2 (20+22+23 = 65).

can someone explain this behaviour?

*The # PMTs measures are 3 different measures.

Thanks!

[v-yulgu-msft · Accepted solution]

Hi @udian,

Please be aware of that in Power BI, filter is worked based on row leve, rather than column level. The same as slicer, Drill Through filters visual with the passed value which is the detailed value under column rather than column/measure header. It is a by design behavior.

Regards,

Yuliana Gu

[udian]

So there is no option for me to get the drill down to the specific measure value that i wnat?

Thanks!