Forum Discussion

gazzo1967's avatar
gazzo1967
Icon for Helper III rankHelper III
3 years ago
Solved

Drill through with measure problem

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

2 Replies

    • hg1l8__'s avatar
      hg1l8__
      New Member

      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.