A drillthrough issue

[bergen288]

I have a table visual for Case_ID drillthrough as shown below.

It works fine with Case_ID filter only when I drillthrough from following page:

However, when I try to drillthrough from another page, it gives me a page with filters for all columns. I have to manually delete filters in yellow box to get correct page.  

Data in all table visuals are from the same fact table.  What's wrong with my 2nd drillthrough and how to fix it? 

Thanks.

[bergen288]

Got it.  Thanks.

[bergen288]

I think I may figure out the root cause of the issue although I don't know why.  In my table visual of "Top 10 Gap Days", only Case_ID is from fact table, all other 3 columns are actually measures so only Case_ID filter is applied.  However, in my 2nd table visual, all columns are from fact table so filters are applied to all of them.  Is there an easy way to address my issue or do I have to define measures for all other columns except Case_ID to avoid unrequired filters?

Thanks.

[v-yanjiang-msft · Accepted solution]

Hi @bergen288 ,

You just need to turn off the option "Keep all filters"

Best regards,

Community Support Team_yanjiang

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