Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 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
Icon for Super User rankSuper User
4 years ago

Do you have an attendance table and a Tier 2Data table or is it just one table you are working with?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      jgeddes
      Icon for Super User rankSuper 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?