Drill through adding additional filters

[indyb]

Hi all, 

I am creating a page which shows the following : 

Employee Name	Department	No of High Rated Errors	No of Low Rated Errors
John Smith	HR	4	2
Michael Jackson	Sales	3	1

The "No of High Rated Errors" and "No of Low Rated Errors" are both CALCULATE(COUNT( measures.

From this I have created a Drill Down Page which shows me the same table as above, but also another table as below : 

Error Type	Flag High Error	Flag Low Error
Error Type 1	Yes
Error Type 2		Yes

I am trying to create the drill down to show that when I select a individual on the first page, drill down by that employee name only to the drilldown page, allowing me to see the "Error Type" and if either "Flag High Error" or "Flag Low Error" is applicable.

Unfortunately at the moment, the drilldown also applies other filters on the drilldown page such as the "No. of High Rated Errors" = 4, which removes the other "Error Types" when drilling through. 

Is it possible to have the drilldown to only have the "Employee Name" Filter when drilling down from the first table?

[amitchandak · Accepted solution]

@indyb , Hope you are talking of drill through

In the drill through you have an option to add drill through the field here. You can remove the filter which you do not want to pass

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

[indyb]

Thanks for the link - it showed what i was looking for. 

Essentially i needed the "Keep All Filters" toggle set to "off" which sorted my issue! 

Thank you!