Forum Discussion

max_bradley's avatar
max_bradley
Frequent Visitor
3 years ago
Solved

Grouped filters in a calculate function

Hi all,   I'd like to caclulate something called persistent absence (PA) for a school. This is defined as the percentage of students that are absent 10% of the time or more.    This can be done v...
Need Help
  • max_bradley's avatar
    max_bradley
    3 years ago

    Just as an update on this for anyone who follows along. A working solution is available here

    PersistentAbs = 
countrows(
filter(
students,
and(
calculate(
StudentAttendances[Attendance%])<.9,
isnumber(
calculate(
StudentAttendances[Attendance%]
)))))

     

v-henryk-mstf's avatar
v-henryk-mstf
Icon for Community Support rankCommunity Support
3 years ago

Hi max_bradley ,

 

Can you provide the relevant test data and screenshots of the expected results and describe them so that I can answer them for you as soon as possible?


Looking forward to your reply.


Best Regards,
Henry