Forum Discussion

mihaita_baro's avatar
mihaita_baro
Icon for Helper II rankHelper II
5 years ago

Ignore slicer value for one column only

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]))

 

General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests

3 Replies

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    5 years ago

    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's avatar
      mihaita_baro
      Icon for Helper II rankHelper II
      5 years ago

      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]))

       

       

      ClientIdCaseloadInitialAssessmentDateReviewCountFollowupCountrevclientIdrevreviewIDrevProviderNamerevreviewDaterevattendedStatusrevsupportcategory
      1166940Iqubal16/09/2020 00:0013011669402752365Health Exchange12/01/2021On time / ahead of staffHigh Intensity: 1st Step
      1169395Iqubal18/09/2020 00:007011693952754498Health Exchange08/01/2021On time / ahead of staffLow Intensity: 1st Step
      1138624Iqubal17/09/2020 00:006011386242756715Health Exchange12/01/2021On time / ahead of staffLow Intensity: 1st Step
      1170432Iqubal10/11/2020 00:005011704322761888Health Exchange07/01/2021On time / ahead of staffLow Intensity: 1st Step