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 |
---|---|
106 | |
88 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |