Forum Discussion
Counting Attendance Percentage per Function
Hi all, My PBI is linked to a Sharepoint which is populated by a Power Apps. The PowerApp is updated once a day, and is meant for Tier reporting. During the submission of the PowerApp, the u...
I agree with what the video told you. If I understand then, your attendence table looks like this
If that is the case then you can take the distinct count of the meeting id to get the number of meetings. Which is what this formula does: calculate(DISTINCTCOUNT(attendanceTable[ID]),All(attendanceTable))
I am thinking the error is occuring when you try to do a distinct count from the other table.
To calculate the attendance percentage for a specific function or event, use this simple formula:
Attendance Percentage = (Number of People Attended ÷ Total Invited People) × 100
Example:
- If 80 people attended a function out of 100 invited:
Attendance Percentage = (80 ÷ 100) × 100 = 80%
This formula helps measure participation effectively.
You can also use the online Attendance Percentage Calculator to save time.