Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
udian
Helper III
Helper III

Drill Through Doesn't Pass Measure Filters - Workaround

Hi,

 

I am trying to use drillthrough in my PBI report.

 

I have the folowing table:

Capture.JPG

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!

1 ACCEPTED SOLUTION
Thejeswar
Resident Rockstar
Resident Rockstar

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)

View solution in original post

3 REPLIES 3
Thejeswar
Resident Rockstar
Resident Rockstar

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)

Thanks for the detailed answer!

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

 

Thanks


Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.