Forum Discussion

UserMFA's avatar
UserMFA
Frequent Visitor
3 years ago
Solved

Select ALL vs No Selection !!!

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

Need Help
Tips and Tricks
Tutorial Requests
  • UserMFA's avatar
    UserMFA
    3 years ago

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

1 Reply

  • UserMFA's avatar
    UserMFA
    Frequent Visitor
    3 years ago

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