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.

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
5 years ago

A column could have been:

I presume your desired solution is a measure then.

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

    Thanks Chris - that is so simple! I'm still a little lost on a measure versus a column, but will take a look.

    TY!

    • ChrisMendoza's avatar
      ChrisMendoza
      Icon for Resident Rockstar rankResident Rockstar
      5 years ago

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