Hi team,
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.
COUNT(Clients[_ROWNUMBER])
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
Any ideas?
Try this:
COUNT(SELECT(Clients[KeyColumn], [_THISROW].[Employer] = [Company ID]))
Thanks for your help.
This worked with one adjustment, I had the Employer and Company ID switched
COUNT(SELECT(Clients[Email], [_THISROW].[Company ID] = [Employer]))
User | Count |
---|---|
44 | |
30 | |
24 | |
23 | |
13 |