How to count attendance of schools from transaction table

Power BI Data Model
2

Hello @pete.langlois,

Thank You for posting your query onto the Forum.

In order to achieve the results based on the condition that you’ve specified. Write a small measure as provided below -

Total Enrolment = 
SUMX(
    DISTINCT( Data[Customer] ) , 
        FIRSTNONBLANK( Data[Enrollment] , 0 ) )

Below is the screenshot of the final results provided for the reference -

Final Results

I’m also attaching the working of the PBIX file for the reference purposes.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh

Enrollment Calculation - Harsh.pbix (17.9 KB)

1 Like