Select ALL vs No Selection !!!

[UserMFA]

Hello,

Any help please !

I need to have to behavor of mesure :

1- If the user clear the slicer then value should be 0 (as shown below)

 2- il select ALL is selected then show total value (sum) : the result below is not ok !

The problem is that isfiltred hase the value FALSE if SelectALL is selected or nothing is selected !!!!

Here below mesures used for this : 

Selection Status =

VAR _selected =

    COUNTROWS ( VALUES ( Feuil5[year]) )

VAR _all =

    COUNTROWS ( DISTINCT ( ALL ( Feuil5[year]) ) )

RETURN

    IF (

        ISFILTERED (Feuil5[year] ),

        IF ( _selected <> _all, IF ( _selected > 1, "Multiple", "Single" ), "ALL" ),

        "Non"

    )

and the result is  : 

Calcul = IF(OR([Selection Status] in {"ALL","Single"},AND([Selection Status] ="Non",ISFILTERED (Feuil5[year]))),count(Feuil5[CCAS]),0)

Thank you in advance for your help

[UserMFA · Accepted solution]

I found finally the solution, it wasn't really simple and hope Power BI team developpement will found a basic solution for this issue