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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Another quick question,

 

As I am pulling out the concantenated values and pulling it into the "Attendance" table, only the departments that are selected in the PowerApp (present departments) are reflected in the table.

 

Is there a way where I can pull ALL departments into the table, but reflect "present" if they are selected, and "absent" if they are not? I think this would make it easier to get the drilldown results that would fit my usecase.

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
3 years ago

If there is a relationship between the master department list and the attendence table you can put the master department list column in your visual that has the attendence measure and select Show items with no data

you should end up with something like