Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |