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.
Go to Solution.
You may also just use the measure below.
VAR w =
MAX ( worker[WorkerId] )
COUNTROWS ( FILTER ( job, job[Worker Id] = w ) )
View solution in original post
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 Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!