I’m trying to create an expression to count client records according to the company ID that they belong to.
I started with this expression below, but realized this is counting all records for all companies.
I’ve tried this as an alternative
COUNT(Clients[_THISROW].[Employer] = [Company ID])
But I get the error that it can’t find the column Employer