Count using DAX with page level filters

[POSPOS]

Hi,

I have a requirement to get three different count.

1. Total Count -- Sum of Active + Pending

2. Active Count -- Count of protocols with Active Date

3. Pending Count -- Count of protocols with blank Active Date

Sample Data:

Table 1:

Table 2:

Based on my requriement,I have a slicer and  I also have to apply page level filters as below:

I am unable to get the active count and total count. Pending count works fine. (Values should change based on slicer selection.)

Sample Pbix file is attached here.

Could someone pls help with the DAX for active count and total count?

Thank you.

[Anonymous]

@POSPOS  Do these expressions work for you?

Active Count =

CALCULATE(

    COUNTAX('Table','Table'[Protocol]),

    KEEPFILTERS(

        NOT ISBLANK(

            'Table'[Active Date]

        )

    )

)

Pending Protocols =

CALCULATE (

    COUNTAX ( 'Table', 'Table'[Protocol] ),

    KEEPFILTERS ( ISBLANK ( 'Table'[Active Date] ) )

)

Total Count =
[Active Count] + [Pending Protocols]

[POSPOS]

@Anonymous 
With the logic for Active Count , I am getting blank. Could you please share the pbix file if possible

[Anonymous]

@POSPOS  If Active Count = Count of protocols with Active Date, and your Active Date filter is (Blank), wouldn't you expect (Blank) in your Active Protocols card?

[POSPOS]

@Anonymous We would still want to show the active count as 5(in this case) in the initial view. Upon making any slicer selection, the action count will be blank.

[Anonymous]

@POSPOS  I'm sorry, but I'm not understanding. Can you be more clear about the requirements?

[POSPOS]

@Anonymous :
As per the same data provided,
Total count=8, Active count=5, Pending Count =3.
I am trying to show the above counts when there are no slicer selections.

When the slicer selection is made, eg: one protocol is selected in the slicer, then I would like to show the counts as
Total count=1, Active count=0, Pending Count =1.

Note: I would still want to retain the page level filters as below

[Anonymous]

@POSPOS  The Active and Pending counts will depend on which Protocol is selected, no?

[POSPOS]

@Anonymous 
We have other slicers are well in the actual report.
To replicate the issue, I have added only protocol as slicer.

[Anonymous]

@POSPOS  Here it is --> click

[POSPOS]

@Anonymous 
Thanks, we would still like to have the page level filters for active date and protocol number.
And the counts should also show in the intial view.

[Idrissshatila]

HEllo @POSPOS ,

check if this is the desired result

Active Protocols = 
CALCULATE(DISTINCTCOUNT('Table'[Protocol]),ALL('Table'),'Table'[Active Date] <> BLANK())

Total Count = 
CALCULATE(DISTINCTCOUNT('Table'[Protocol]),ALL('Table'))

[POSPOS]

@Idrissshatila 
In the initial view the values for active count should show as 5 and when any slicer selections are made the value will be blank.

[POSPOS]

@Idrissshatila 
Values are as expected, but we also want the values  to change with slicers selection.
Now, the values are not changing with slicer selection.