Calculate the number of reps completed 20 or more tasks in a given week

[actzikas]

I have two tables

Table 1 = Task (Contains rows of the Owner ID and what tasks were created)

Table 2 = Number of BDRs

Table 2 will have two columns

Column 1 - Start of Week 

Column 2 - Calculated Measure that counts the number of reps who completed 20 tasks are more in Table Task

I need help on creating Column 2 - Basically I want some kind of Count by Owner ID if they completed 20 or more tasks in a given week based on the Related table Task. This will act as an "identifier" if they were present for the full week or not. 

[v-lionel-msft]

Hi @actzikas ,

Which columns does Table 1 and Table 2 use to create the relationship?

Could you give a sample data model?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

Can you share sample data and sample output. Thanks.
Proud to be a Datanaut My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...