Forum Discussion

renanpinheiro's avatar
renanpinheiro
Icon for Advocate II rankAdvocate II
9 years ago
Solved

Calcular nota

I have the following situation:


I have a table where each user appears 19 times.

 

Each time it receives a note (0 or 1) for the answer presented on the line.

 

I created a measure in which I am the notes and divide by the total of lines, to find the average of the note of each user.

 

Now I need to calculate how many users took below 75% (0.75) and how many took more than 75% (0.75), but I do not know how to do it

  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    renanpinheiro

     

    In this scenario, I suggest you create a score measure to calculate the answer rate for each student, then create a summarized table with stundent column and score column only. After that you can create measures to count the stundents for different bucket. Please refer to my sample below:

     

     

     

     Create a summarized table with student and score column only.

     

    Table = ADDCOLUMNS(
SUMMARIZECOLUMNS(Table1[Student]),
"Score",
CALCULATE(SUM(Table1[Answer]),ALLEXCEPT(Table1,Table1[Student]))/CALCULATE(COUNTROWS(Table1),ALLEXCEPT(Table1,Table1[Student]))
)

     

     

    Then you can create two measures and populate them into card visual:

     

    Above 75% = CALCULATE(COUNTA('Table'[Student]),FILTER('Table','Table'[Score]>=0.75))

     

    Below 75% = CALCULATE(COUNTA('Table'[Student]),FILTER('Table','Table'[Score]<0.75))

     

     

    Regards,

4 Replies

  • BhaveshPatel's avatar
    BhaveshPatel
    Icon for Super User rankSuper User
    9 years ago

    Hi renanpinheiro

     

    You should sum the no of answered notes by

     

    Answered:=SUM(Table1[Notes])

     

    You already have the total count of notes.

     

    Percentage:=DIVIDE([Answered],[Total Count of Notes],2)

     

    This will give you the percentages and after that with if function, you can find how many of them answered below 75 % and above 75%.

     

     

    • renanpinheiro's avatar
      renanpinheiro
      Icon for Advocate II rankAdvocate II
      9 years ago

      Hi BhaveshPatel,

      I need a measure to count students below 75% and another measure to count students above 75%.

      Can you help me?

    • renanpinheiro's avatar
      renanpinheiro
      Icon for Advocate II rankAdvocate II
      9 years ago

      BhaveshPatel

      What I need is the following:
      I need to count how many students, by test, had scores below 75% and how many had scores above 75%. Number of students per test.

      • v-sihou-msft's avatar
        v-sihou-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        renanpinheiro

         

        In this scenario, I suggest you create a score measure to calculate the answer rate for each student, then create a summarized table with stundent column and score column only. After that you can create measures to count the stundents for different bucket. Please refer to my sample below:

         

         

         

         Create a summarized table with student and score column only.

         

        Table = ADDCOLUMNS(
SUMMARIZECOLUMNS(Table1[Student]),
"Score",
CALCULATE(SUM(Table1[Answer]),ALLEXCEPT(Table1,Table1[Student]))/CALCULATE(COUNTROWS(Table1),ALLEXCEPT(Table1,Table1[Student]))
)

         

         

        Then you can create two measures and populate them into card visual:

         

        Above 75% = CALCULATE(COUNTA('Table'[Student]),FILTER('Table','Table'[Score]>=0.75))

         

        Below 75% = CALCULATE(COUNTA('Table'[Student]),FILTER('Table','Table'[Score]<0.75))

         

         

        Regards,