SharePoint List Participation

[Kincaid16]

Hello, 

Im trying to calculate percentages of participation on a sharepoint list. I have two tables one with a list of people who are required to fill out a form on the sharepoint list and the other is the list its self. 

Ex.

Table 1

Name

Jim

Jane

Jerry

Table 2. 

Name	Date	Question 1
Jim	5/1/2022	yes
Jerry	5/7/2022	no

Is there a way to make a measure or created column to calculate who participated. 

Any help is appreaciated. 

Thanks 

[amitchandak · Accepted solution]

@Kincaid16 , hope the two tables are joined on Name

Divide(countrows(filter(Table2, Table2[Question]="yes")), counttows(Table1))