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 th...
  • 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 ) )
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 ) )