Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all, I have this similar table:
Name Project
Jose Carlos A
David Fernandez B
Carlos Andres C
Jose Carlos D
Jose Carlos E
Andrea Marin F
I need a card to count the total number of projects per person.
For example, if I use a slicer for projects and I choose Project A the card shows me that Jose Carlos has 3 projects.
Thanks a lot
Hi @Anonymous ,
You can use the below measure.
@harshnathani 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.
Thanks
Hi @Anonymous ,
You can use the below measure:
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 () )
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
@harshnathani 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.
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.
Hello:
If I understood correctly, you need something like this
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
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
110 | |
96 | |
95 | |
74 | |
71 |