Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
User | Count |
---|---|
123 | |
69 | |
67 | |
58 | |
52 |
User | Count |
---|---|
185 | |
92 | |
67 | |
62 | |
52 |