Solved: Issue with Manage Relationship

AbdullahKhalid · ‎11-13-2017

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.

v-chuncz-msft · ‎11-14-2017

@AbdullahKhalid,

You may also just use the measure below.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎11-14-2017

@AbdullahKhalid,

You may also just use the measure below.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BeemsC · ‎11-13-2017

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