Count Number of Instances in a related table

[DemingPDCA]

I have a few tables that look like this:

_User Table:

Email	Business Unit	Plant
Person1@company.com
Person2@company.com

SRA ProjectPlace Members:

Email	Member ID	Last Active
Person1@company.com	ABCDEFG
Person2@company.com	1234567

SRA Member Roles

Member ID	WorkspaceID	Role Name
ABCDEFG	XXXXXXXXXX	Role 1
ABCDEFG	YYYYYYYYYYY	Role 2
1234567	XXXXXXXXXX	Role 2
1234567	YYYYYYYYYYY	Role 3

I'd like to be able to count for each person how many different projects (workspace IDs) they are listed as "Role 1" vs "Role 2" etc on, and how many different projects they are listed on at all, or if they are listed on none. I'm not sure if my relationships aren't right, but I can't seem to get the formula to work. I've beein trying to do it in a measure - does it need to be a calculated column instead?

[I_NeedMorePower · Accepted solution]

Hi DemingPDCA,

Please try creating a calculated column on your user table and use the function "COUNTX" for the column.

Please check this post.

I think it has the same requirement you are looking for.