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.
Solved! Go to Solution.
You may also just use the measure below.
Measure = VAR w = MAX ( worker[WorkerId] ) RETURN COUNTROWS ( FILTER ( job, job[Worker Id] = w ) )
You may also just use the measure below.
Measure = VAR w = MAX ( worker[WorkerId] ) RETURN COUNTROWS ( FILTER ( job, job[Worker Id] = w ) )
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
Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.
Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!
Join the biggest FREE Business Applications Event in LATAM this February.
User | Count |
---|---|
210 | |
49 | |
45 | |
44 | |
42 |
User | Count |
---|---|
261 | |
211 | |
103 | |
79 | |
66 |