I’m currently working with two tables. In my EMPLOYMENTS table, the Member_C column contains the User IDs of people who have/had a job. The User ID appears once for each job a person have/had. In my INDIVIDUAL table, the ID column lists all User IDs in the system. I want to set up a new column in the INDIVIDUAL table that counts the number of times a User ID appears in the EMPLOYMENTS table if it matches the User ID of each row in the INDIVIDUAL table.
I know how to do this in Excel, but I’m very new in using DAX functions. I need to get the DAX equivalent for this formula:
Looking forward to your suggestion/s!