Forum Discussion

geoffgarcia's avatar
geoffgarcia
Icon for Helper I rankHelper I
5 years ago
Solved

Count rows in another table that match the current row

I've spend a healthy amount of time looking for a solution and am posting here as a last hope. I have a table of offices and a table of employees, and very simply need to find a count of all employe...
Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    5 years ago

    Looks like it works as a measure too. I did have to tell the column to SUM though.

geoffgarcia's avatar
geoffgarcia
Icon for Helper I rankHelper I
5 years ago

The rule of Geoff is within 5 minutes of asking a question I figure it out on my own. I believe the answer is:

EmployeeCount = 
var _CurrentRowValue = Office[Office_ID]
RETURN
COUNTROWS(
    Filter(Employees,
    _CurrentRowValue=Employees[Employee_ID]
))