Forum Discussion

bergen288's avatar
bergen288
Helper IV
3 years ago
Solved

A drillthrough issue

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 fr...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    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.

bergen288's avatar
bergen288
Helper IV
3 years ago

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's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    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.