Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
General Comment
Need Help
  • jgeddes's avatar
    jgeddes
    3 years ago

    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.

     

jgeddes's avatar
jgeddes
Super User
3 years ago

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.

 

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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?