Forum Discussion
Drillthrough Filter is Wrong
Hi all,
I've been looking around but unable to find an answer to my problem.
I have multiple measures added to drill through. When I drill through MTD on Time column which is 3, in theory, it should return 3 items in the Data tab.
Here is my formula
MTD Ontime = CALCULATE(COUNT([Item]),FILTER(Data,[Status] = "On-Time"))
So the result it returns 4 items notice my measure above Status filtered = "On-Time". How come Late status displayed?
How do I fix this issue?
Here is my dummy report
I really appreciated your help.
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.
3 Replies
Hi 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
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.
