drillthrough not working - not applying the filter on the measure

[Anonymous]

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?

[Deji]

Experienced the same problem but fixed it. keep the measure in the table but remove the column of which the measure is referencing. then put the column back into the table. e.g. below keep the apples only measure count in the table but remove the [Type] column, then put the [Type] column back in.
Apples only = CALCULATE( [Total no of Orders], FILTER ('FRUIT', 'FRUIT'[Type] = "Apple"))

[Deji]

Also do ensure that your £Total is a measure not the sum of a [Column]

[v-yulgu-msft]

Hi @Anonymous,

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

Regards,

Yuliana Gu

[Anonymous]

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

[v-yulgu-msft]

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

[zlokesh]

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]

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. 

numbers to drill onResult. Detail on 8 records instead of 2

[sokg]

Uncheck the data