Some help required with a measure

Hi Simon_Evans 

Thanks for reaching out to us.

>>  I need a measure that counts the number of students where their attendance is less than or equal to 0.90.

try

attendance=Total Present Marks / Total Marks

then set it to 2 decimal places.

rows= calculate(countrows('table'),filter(all('table'), [attendance]<=0.9))

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

Assuming any Attendance code will do, you could start by simplyfying your formula by using SessionAttendace[AttendanceCode]<>NULL().

My idea is:

Attendance Rate=
    DIVIDE(
        CALCULATE(
            COUNT('SessionAttendance'[AttendanceCode]),
            FILTER(SessionAttendance, [AttendanceCode]<>NULL()) //filter for sessions attended only
        )                                                       //------------------------------------
        COUNT('SessionAttendance'[AttendanceCode]),             //I'm assuming there's no condition on
        2                                                       //what you consider as "Valid session"
    )                                                           //for your statistics

and then

lessThan90=
    CALCULATE(
        DISTINCTCOUNT('SessionAttendance'[StudentID]),
        FILTER('SessionAttendance', [Attendance Rate]<=0.9)
    )

Let me know if this helps.