Forum Discussion
Solved
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 Resourc...
The value where the Match column is "False" is your result set.
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.
That works! Thanks!