Count filtering

Question

Hi all, I have this similar table:&nbsp;Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ProjectJose Carlos&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ADavid Fernandez&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BCarlos Andres&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CJose Carlos&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; D&nbsp; &nbsp;Jose Carlos&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; EAndrea Marin&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; F&nbsp;I need a card to count the&nbsp;total number of projects per person.&nbsp;For example, if I use a slicer for projects and I choose Project A the card shows me that Jose Carlos has 3 projects.&nbsp;Thanks a lot

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;You can use the below measure.&nbsp;Count of Projects = var _cc = COUNT(ProjectDetials[Name])Var _sel = SELECTEDVALUE(ProjectDetials[Name])returnif (ISBLANK(_sel),CONCATENATE("Total Project ",_cc),CONCATENATE(CONCATENATE(CONCATENATE(_sel, " has "),_cc)," projects "))&nbsp;&nbsp;&nbsp;Regards,Harsh Nathani&nbsp;&nbsp;Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!In case it does not help, please provide additional information and mark me with @

anonymous · Answer

Anonymous&nbsp;it actually works when i use a Slicer for Name, but i need it to work with a Project Slicer. Example: in a slicer for project a choose A then the card will show the total projects of the person for the Project A in this case 3 projects.&nbsp;Thanks

petazo · Answer

Hello: If I understood correctly, you need something like this Targeted Photos    Untargeted Photo    The idea is that per user will show you the total of projects assigned to it, and by segmenting it shows only the user or users assigned to the project with all the pro-tests assigned Is that all right?  The formula is in the picture. I'm reviewed. Best regards

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;You can use the below measure:&nbsp;COUNT of Projects =
VAR _cc =
    COUNT ( ProjectDetials[Name] ) 
VAR _sel =
    SELECTEDVALUE ( ProjectDetials[Name] ) 
VAR _sel1 =
    SELECTEDVALUE ( ProjectDetials[Project] ) 
VAR _name =
    VALUES ( ProjectDetials[Name] ) 
VAR _ccx =
    CALCULATE (
        COUNT ( ProjectDetials[Project] ),
        FILTER (
            ALL ( ProjectDetials ),
            ProjectDetials[Name]
             =
                _name
        )
    )
return
    SWITCH (
        TRUE (),
        NOT ( ISBLANK ( _sel1 ) ),
        CONCATENATE (
            CONCATENATE ( CONCATENATE ( _name, " has " ), _ccx ),
            " projects "
        ),
        NOT ( ISBLANK ( _sel ) ),
        CONCATENATE (
            CONCATENATE ( CONCATENATE ( _sel, " has " ), _cc ),
            " projects "
        ),
        ISBLANK ( _sel ),
        CONCATENATE ( "Total Project ", _cc ),
        ISBLANK ( _sel1 ),
        CONCATENATE ( "Total Project ", _cc ),
        BLANK ()
    )&nbsp;&nbsp;Regards,Harsh Nathani&nbsp;Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

anonymous · Answer

Anonymous&nbsp;Hi, I tried it but still the filter for name has to be marked. Also I need it to just show the value 3 and not Jose Carlos has 3 projects.&nbsp;&nbsp;&nbsp;&nbsp;COUNT of Projects = VAR _cc =COUNT ( Lider[Líder] ) VAR _sel =SELECTEDVALUE ( Lider[Líder]) VAR _sel1 =SELECTEDVALUE ( Lider[Proyecto] ) VAR _name =VALUES ( Lider[Líder] ) VAR _ccx =CALCULATE (COUNT ( Lider[Proyecto] );FILTER (ALL ( Lider );Lider[Líder]=_name))returnSWITCH (TRUE ();NOT ( ISBLANK ( _sel1 ) );CONCATENATE (CONCATENATE ( CONCATENATE ( _name; " has " ); _ccx );" projects ");NOT ( ISBLANK ( _sel ) );CONCATENATE (CONCATENATE ( CONCATENATE ( _sel; " has " ); _cc );" projects ");ISBLANK ( _sel );CONCATENATE ( "Total Project "; _cc );ISBLANK ( _sel1 );CONCATENATE ( "Total Project "; _cc );BLANK ())Thanks a lot.&nbsp;

Forum Discussion

Related content

Filter participant counts

Filter and Count

Counting nulls

Help with matrices slicers, filters and dynamic counts

Count Of Drivers