Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@Kincaid16 , hope the two tables are joined on Name
Divide(countrows(filter(Table2, Table2[Question]="yes")), counttows(Table1))
@Kincaid16 , hope the two tables are joined on Name
Divide(countrows(filter(Table2, Table2[Question]="yes")), counttows(Table1))
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
112 | |
100 | |
98 | |
72 | |
66 |