Issue with Manage Relationship

[AbdullahKhalid]

Hi,

i am new to this. i have 2 tables my issue is that i have to get a result that displays number of jobs allocated to each worker name. i dont understand how to make the relation between the two tables. I appreciate your help.

[BeemsC]

It looks like you've already made a relationship on the given picture?
Im guessing you just can relate workerid from both tables?
Do you get any errors? what is the problem

[v-chuncz-msft · Accepted solution]

@AbdullahKhalid,

You may also just use the measure below.

Measure =
VAR w =
    MAX ( worker[WorkerId] )
RETURN
    COUNTROWS ( FILTER ( job, job[Worker Id] = w ) )