cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

drillthrough not working - not applying the filter on the measure

Hi ,

 

I want to drill through on a measure - but this not applying the filter ON the measure definition.

 

E.g. the table below is for vouchers

Date--------------Total-----Paid----Created-----Cancelled

1-1-2017----------100------10------70-----------30

 

Total: All

Created : Status 4 or 5

cancelled : Status 99

Paid : Status 5

 

if i drill down on Paid 10 - this should give me the 10 voucher details. instead it gives me all 100. It does not apply the measure filter. Am i missing something?

 

6 REPLIES 6
sokg Established Member
Established Member

Re: drillthrough not working - not applying the filter on the measure

Uncheck the data

 

 

Select sub-menu for a bookmark by using the ellipses

zlokesh Member
Member

Re: drillthrough not working - not applying the filter on the measure

Hi @Anonymous,

              In general Drill through filter should apply on the second page( where details are there) I mean where 10 voucher information is stored and on basic of column DATE or PAID you can apply in second page.

Once you right click on your first page visualization then you can go to your second page.

It would be great if you share the screenshot and some details so that can have detailed picture for same.

Thanks

Anonymous
Not applicable

Re: drillthrough not working - not applying the filter on the measure

Yes It goes a second page that has the detail columns

 

It works for totals but not for measures that have a filter on them e.g. 

 

SnipImage.JPGnumbers to drill onSnipImage.JPGResult. Detail on 8 records instead of 2

Community Support Team
Community Support Team

Re: drillthrough not working - not applying the filter on the measure

Hi @Anonymous,

 

Which field did you add to "DrillThrough" section on the second page?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: drillthrough not working - not applying the filter on the measure

Added to all calculated measures (total, paid cancelled etc)

Community Support Team
Community Support Team

Re: drillthrough not working - not applying the filter on the measure

Hi @Anonymous,

 

I was not able to replicate this problem on my side. If possible, would you please share your .pbix file for further check? If upload, please remove all unnecessary and unrelated tables and columns.

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.