Count if conditions are met

[Anonymous]

Hello - 

Trying to do some demographics on projects.

Multiple projects with multiple individuals working on them spanning across different office locations (Department). 

I want to know how to identify how many projects have 2 or more (or 3 or more...4 or more) from the same office(department) working on them? I've created a table with just unique project ID's and i'd like to see a calculated column or something denoting if that project has 2/3/4 or more from same office working on it. Maybe even measures? Ideally, I'd get to see it by Employee type... Project support, Job captain etc... any help would be GREATLY appreciated.

[amitchandak]

@Anonymous ,

Try a new measure like

countx(filter(summarize(Table,Table[projectID], table[department],"_1", count(table[Name1])),[_1]>=2),[projectID])

[Anonymous]

Thank you @amitchandak 

Which relationships should I have active?/make active? I have my Name.1 relationship active.... as Table 'Active Employees' has the names and their locations. The 'Hours Distribution' table has all of the projects listed with the individuals.

[edhans]

COUNTX() is likely what you want as you can nest a FILTER() function to filter data by the table it needs, and it can have its own expression. But we would need actual data to play with. See links below.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum