Need Help Pulling a count from this list

[shawn3474]

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.

[Salonic]

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

[shawn3474]

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.

[abhishekpati86 · Accepted solution]

The value where the Match column is "False" is your result set.

[shawn3474]

That works!  Thanks!