Forum Discussion
Count filtering
Hi all, I have this similar table: Name Project Jose Carlos A David Fernandez B Carlos Andres C Jose...
Anonymous 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.
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
)
)
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 ()
)
Thanks a lot.
Anonymous ,
Not sure how the filter of name can be marked when you are selecting the projects. These are 2 independant objects.
Anyways, here is the code for showing the no. of projects i.e value 3.
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)),_ccx,
NOT(ISBLANK(_sel)),_cc,
ISBLANK(_sel),_cc,
ISBLANK(_sel1),_cc,
BLANK()
)
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!