Forum Discussion
Need Help Pulling a count from this list
I am trying to show number of active projects a team is working on. The problem I have is the way the data is stored in the table.
| Project_Name | Teams.Value | TeamsWorkCompleted.Value | ResourceAssigned | StageValue |
| Project A | AppTech | DBA | Jim | In Progress |
| Project A | AppTech | Unix | Dan | In Progress |
| Project A | AppTech | Windows | Greg | In Progress |
| Project A | DBA | DBA | Jim | In Progress |
| Project A | DBA | Unix | Dan | In Progress |
| Project A | DBA | Windows | Greg | In Progress |
| Project A | Unix | DBA | Jim | In Progress |
| Project A | Unix | Unix | Dan | In Progress |
| Project A | Unix | Windows | Greg | In Progress |
| Project A | Windows | DBA | Jim | In Progress |
| Project A | Windows | Unix | Dan | In Progress |
| Project A | Windows | Windows | Greg | In Progress |
| Project B | Network | Web | Shawn | In Progress |
| Project B | Web | Web | George | In Progress |
| Project B | Network | Web | Shawn | In Progress |
| Project B | Web | Web | George | In Progress |
What I am trying to do is show a count for each team where the stagevalue is set to In Progress and Teams.Value is not showing up under TeamsWorkCompleted.Value for a given project. In the example above only AppTech has work left to be completed for Project A so count that as 1 project for AppTech. DBA, Unix, and Web would not have any count for Project A as they have a value in the TeamsWorkComplete.Value column. If through the rest of the table AppTech has another project where they have yet to complete the work then they would have 2 projects. Hope this makes sense.
The value where the Match column is "False" is your result set.
4 Replies
Hello,
You need 3 measures :
NbTeams = DISTINCTCOUNT(Projects[Teams.Value])
The number of different teams who work on a project
NbTeamsComplete = DISTINCTCOUNT(Projects[TeamsWorkCompleted.Value])
Number of teams who complete their jobs
NbNotComplete = [NbTeams]-[NbTeamsComplete]
Number of teams who still have work to do
Not quite what I am looking for. That gives me the number of teams that have work to do, I am looking to show the name of the teams that have work to do.
The value where the Match column is "False" is your result set.
