Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
Expand all | Collapse all

Urgent Query _ Count Total Students Who Evaluated

  • 1.  Urgent Query _ Count Total Students Who Evaluated

    Posted Aug 05, 2022 04:19 AM
      |   view attached
    I have been stuck in this query for long time, need your help.

    Attached is the dataset of teacher_evaluation. I already have the total respondents (TTL_STUDNTS) for each section, but i want to calculate the total students who evaluated each teacher (EVLTD_STUD). Data needs to be grouped by columns highlighted in yellow.

    Answer for teacher_1 who taught section B2 should be 2 students (as already written for your understanding).

    ------------------------------
    Gulfam Ahmad
    Head of Analytics
    ------------------------------

    Attachment(s)



  • 2.  RE: Urgent Query _ Count Total Students Who Evaluated

    Posted Aug 08, 2022 06:25 PM
    Hello Gulfam,  give a try to: DISTINCTCOUNT([REG_NBR] ).

    Regards
    Normand


    ------------------------------
    Normand Tousignant
    Consultant ERP
    LA PRAIRIE QC
    4383403863
    ------------------------------