Power BI Exchange

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

View My Drafts

  • 1.  Urgent Query _ Count Total Students Who Evaluated

    Posted 5 days ago
      |   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)

    xlsx
    Query_Count_Evaluated_Students.xlsx   827 KB 1 version


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

    Posted 2 days ago
    Hello Gulfam,  give a try to: DISTINCTCOUNT([REG_NBR] ).

    Regards
    Normand

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

    Original Message