Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |