Ignore slicer value for one column only

[mihaita_baro]

Hi there,

I have a table where it show nr of clients per practitioners. and a slicer from a Date table.

THis is the table i want to drill through IAPT Clients to another table ( see below ) and be able to see the Cient ID and All Sessions and Eligible Session ( i have measure for these 2 )

The problem is that when i drill through i don't see only 3 client ID's because my other 2 measure have ALL function to ignore the Slicer selection because some sessions are in the past and i want to count them all.

So how can i see only those 3 Client ID's but also counting all the sessions from the past ?

All Client Eligible Sessions IAPT = CALCULATE(DISTINCTCOUNT('All Sessions IAPT'[revreviewID]),'All Sessions IAPT'[revsupportcategory]<>BLANK(),ALL('Date'[Month],'Date'[Financial Quarter],'Date'[Financial Year]))

All Client Sessions IAPT = CALCULATE(DISTINCTCOUNT('All Sessions IAPT'[revreviewID]),ALL('Date'[Financial Year],'Date'[Month],'Date'[Financial Quarter]))

[v-henryk-mstf]

Hi @mihaita_baro ,

According to your question, the measure formula and screenshots provided above are not enough for me to do further testing. Whether you can provide test data (delete sensitive information), I will answer for you as soon as possible.

Looking forward to your reply.

Best Regards,
Henry

[mihaita_baro]

Hi @v-henryk-mstf 

Have you got any answer please ?

[mihaita_baro]

Hi @v-henryk-mstf 

so the issue i am facing is that when i drill through i don't see only those 4 clients, becuase i am using the ALL function to get rid of the year, quarter, month filters becasuse some session of the clients may have been in june, may or april or march and i want to count them all.

and for that reason is not showing me only 4 clients ID with their number of sessions, it shows all clients ID's

So i only want to see only those 4 clients ID's and with their number of sessions.

I have a date table ( calendar ) and the below table :

In the drill thrgouh table i have the below measure for all client sessions

All Client Sessions IAPT = CALCULATE(DISTINCTCOUNT('All Sessions IAPT'[revreviewID]),ALL('Date'[Financial Year],'Date'[Month],'Date'[Financial Quarter]))

ClientId	Caseload	InitialAssessmentDate	ReviewCount	FollowupCount	revclientId	revreviewID	revProviderName	revreviewDate	revattendedStatus	revsupportcategory
1166940	Iqubal	16/09/2020 00:00	13	0	1166940	2752365	Health Exchange	12/01/2021	On time / ahead of staff	High Intensity: 1st Step
1169395	Iqubal	18/09/2020 00:00	7	0	1169395	2754498	Health Exchange	08/01/2021	On time / ahead of staff	Low Intensity: 1st Step
1138624	Iqubal	17/09/2020 00:00	6	0	1138624	2756715	Health Exchange	12/01/2021	On time / ahead of staff	Low Intensity: 1st Step
1170432	Iqubal	10/11/2020 00:00	5	0	1170432	2761888	Health Exchange	07/01/2021	On time / ahead of staff	Low Intensity: 1st Step