Forum Discussion

AbdullahKhalid's avatar
AbdullahKhalid
Regular Visitor
8 years ago
Solved

Issue with Manage Relationship

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's avatar
    v-chuncz-msft
    8 years ago

    AbdullahKhalid,

     

    You may also just use the measure below.

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

2 Replies

  • BeemsC's avatar
    BeemsC
    Resolver III
    8 years ago

    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's avatar
    v-chuncz-msft
    Community Support
    8 years ago

    AbdullahKhalid,

     

    You may also just use the measure below.

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