Drill Through Doesn't Pass Measure Filters - Workaround

[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).

*The # PMTs measures are 3 different measures.

I got an explanation that this is the expected behaviour as PBI filter works on row level insted of column level.

I didn't quite understand this explanation and also wnated to know if there is any workaround as it seems like a basic thing.

can someone elaborate?

Thanks!

Thanks!

[Thejeswar · Accepted solution]

Hi @udian,

I think the functionality of Matrix Drill-through that you experience is perfectly fine.

Also to note, the Column values also pass in a drill-through as long as they are columns.

But since in your case, you are using a measure in your column, it can be told that the one you are having is not an ideal Matrix (as matrix compares a value against two attributes).

Also, my guess is you are filtering your value based on some condition in each of your three measures and displaying in matrix. When you drill through, there will be no item in your detail report on which your measure can filter up on and hence your measures are not passing to your detail report

Instead, as a workaround, you should look at having #PMTs Range1, #PMTs Range2, #PMTs Range3 as a single column value and build a matrix using that as Column Headers.

Note: These Column can be populated based on conditions record by record similar to the one given below

Ex; Col = If (A=B, '#PMTs Range1', IF(A=C, #PMTs Range2, #PMTs Range3))

The Above statement has to be modified as per your need

Use the column Col created as your column header and the measure as your value.

Now this can be passed to your detail report. (Limitation might be you will have to display this column in your detail report. Not sure about this anyway)

[udian]

Thanks for the detailed answer!

[harib]

Have u got the answer. Can u please provide the sample file. I am also facing the same issue

Thanks

---