Forum Discussion
Helper VDrillthrough Filter is Wrong
But if we don't use columns contains both Region and Status in the Summary page, we can't transfer the filter to the Data page. Measure cannot work in this scenario.
As another workaround, we can create another copy of Data page which contains a page level filter with Status = On-Time, then drill through to this page.
Solution SageHi Stuznet,
According to your description, my understand is that you want to filter out the data in specified region of the status “On-Time”.
The drill through function will transfer the filters which you have added to the DrillThrough filter in the focused page from the current report page to the focused page.
In your scenario, the measure “MTD Ontime” you added to DrillThrough filter will not affect the result data, the only filter you transferred to Data page is the Region. As a result, we will see the result of all data from West.
In order to filter both Region and Status, we need to add these two fields to DrillThrough filter, then add an visual in the Summary page which contains Region and Status.
Then we can right-click on the West – On-Time row, click Drill Through.
Best Regards,
Teige
StuznetHi, TeigeGao
I thought something I can modify the formula without having to add an additional field to the table. But the method from above you mentioned is not going to for me. Thank you though
- TeigeGao
But if we don't use columns contains both Region and Status in the Summary page, we can't transfer the filter to the Data page. Measure cannot work in this scenario.
As another workaround, we can create another copy of Data page which contains a page level filter with Status = On-Time, then drill through to this page.