Drill through with measure problem

[gazzo1967]

HI All 🙂
I am having a problem (probaly down to lack of knowledge) with a drill thorough on the final page of my report.

I am using this measure to apply the counts on my report pages

ROLE_BA_FireCount =

CALCULATE (

    COUNTROWS ( ROLE_COUNT_IND ),

    SEARCH ( "BA Wearer", ROLE_COUNT_IND[Role_BA],, 0 )

        && SEARCH ( "Required standard achieved", ROLE_COUNT_IND[answer],, 0 )

        && SEARCH ( "Fire", ROLE_COUNT_IND[attended],, 0 )

       ) + 0


So this is the table on the previous page
so under the fire column  you can see a '2'

So on the next page if i drill thorugh i would like to see just those 2 records detail

I have FULL_NAME and the 'fire' columns in the Drill through filter
But when I get to my final page  It show the persons entire set of records and not just the 2 in the table on the previous page.
The FULL_NAME is taken from table A
The ROLE_BA_FireCount measure is from table B

The activity_date is from table B

The relationship is on email  in each table with Cross filter set to both ways
Do i use KEEP ALL FILTERS?

Thanks in advance Gary

[amitchandak · Accepted solution]

@gazzo1967 , add measure visual level filter and filter for ROLE_BA_FireCount <> 0

[hg1l8__]

Can I ask why this is required? It means that the drill through page cannot be used for other measure drill throughs as the page is restricted.