Forum Discussion
Counting Attendance Percentage per Function
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.
Super UserDo you have an attendance table and a Tier 2Data table or is it just one table you are working with?
Hi,
To clarify, I have 2 tables.
So the original field I get from PowerApps concantenates all the different departments together. I watched a video and was told that it would be best to split out that column and create a new table which is illustrated in the images in the original post.
- jgeddes
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.
That worked! Thank you!
If I wanted to then create a filter to drill down the percentage such that it will change according to the month, may I know how I can do that?- jgeddes
Happy it worked for you.
If you want to filter by date you will need to have whichever table contains both meeting id and the date the meeting was held related to the attendence table by meeting id.
You would then be able to use the meeting dates to filter the attendence results.