Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
shawn3474
Frequent Visitor

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_NameTeams.ValueTeamsWorkCompleted.ValueResourceAssignedStageValue
Project AAppTechDBAJimIn Progress
Project AAppTechUnixDanIn Progress
Project AAppTechWindowsGregIn Progress
Project ADBADBAJimIn Progress
Project ADBAUnixDanIn Progress
Project ADBAWindowsGregIn Progress
Project AUnixDBAJimIn Progress
Project AUnixUnixDanIn Progress
Project AUnixWindowsGregIn Progress
Project AWindowsDBAJimIn Progress
Project AWindowsUnixDanIn Progress
Project AWindowsWindowsGregIn Progress
Project BNetworkWebShawnIn Progress
Project BWebWebGeorgeIn Progress
Project BNetworkWebShawnIn Progress
Project BWebWebGeorge

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.

 

1 ACCEPTED SOLUTION

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

image.png

 

 

 

View solution in original post

4 REPLIES 4
Salonic
Resolver I
Resolver I

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.

image.png

 

 

 

That works!  Thanks!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.