Forum Discussion
gazzo1967
Helper III
3 years agoDrill 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 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 ROLE_BA_FireCount measure is from table B
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
gazzo1967 , add measure visual level filter and filter for ROLE_BA_FireCount <> 0
2 Replies
- amitchandak
Super User
gazzo1967 , add measure visual level filter and filter for ROLE_BA_FireCount <> 0
- 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.