Bypass Keep All Filters on Drillthrough

[Anonymous]

Can someone help please. 

When I drillthrough with a Measure the 'Keep all filters' automatically comes on. 

It is the reason the Janruary data is showing and I need to somehow bypass this. 

The expected result is so see the top 3 values only 

Does anyone know how I can do this?

Measure data is below - 

Example1 =

SWITCH(

TRUE(),

'New - Timesheet 2021'[Hours2] >=0 && 'New - Timesheet 2021'[Hours2] <=15, 0,

'New - Timesheet 2021'[Hours2] >=16 && 'New - Timesheet 2021'[Hours2] <=30, 0.5,

'New - Timesheet 2021'[Hours2] >=31 && 'New - Timesheet 2021'[Hours2] <=60, 1

)

[Anonymous]

Hi @amitchandak thanks for your response. so is there a way I can convert my measure into a column so I can use that in a bar graph? 

thanks 

[v-zhangti · Accepted solution]

Hi, @Anonymous 

You can refer to the following methods. Your formula is fine no need to change it.

Put Example1 in Filters, set to not equal to 0.

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I drill through we can pass only value from one row, not more than that.

Keeping all filters means all filters will pass. And you switch it off. Whatever is below that will be passed

Measure will not pass any filter information. Measure in drill down page can control