Forum Discussion

Matthias93's avatar
Matthias93
Icon for Helper III rankHelper III
9 years ago
Solved

Calculating the submittance rate

Hi,   In my dataset I want to be able to see the percentage of people that respond to a certain survey. Do do this I have 2 relevant columns. One with an Id for every form  (so 1 unique id per form...
Need Help
  • v-caliao-msft's avatar
    v-caliao-msft
    9 years ago

    Hi Matthias93,

     

    I i don't think you can get the response rate for each month, since if the submitted is blank, Power bi cannot determine which month this record belog to. So we can only get the over all response rate.

    If each id-check-in belog to a month, then you can get the response rate for each month.

    ResponseRate = CALCULATE(COUNTA('Check-in'[Submitted]),ALLEXCEPT('Check-in','Check-in'[Month]))/CALCULATE(COUNTA('Check-in'[Id-check-in]),ALLEXCEPT('Check-in','Check-in'[Month]))

    Regards,

    Charlie Liao

  • Matthias93's avatar
    Matthias93
    Icon for Helper III rankHelper III
    9 years ago

    This is very close to what I want, I'm quite a beginner with Power BI. Is this the right measure? (my table is called Check-in.)

     

    Response rate = COUNT(Check-in [Submitted])/COUNT(Check-in[Id-check-in]). This gives me a 'token literal expected' error.

     

    Thanks for helping!

     

    Matt

    • Vvelarde's avatar
      Vvelarde
      Icon for Community Champion rankCommunity Champion
      9 years ago

      Matthias93

       

      where are creating the measure

       

       

      you can create in this place

      new measure

      • Matthias93's avatar
        Matthias93
        Icon for Helper III rankHelper III
        9 years ago

        Vvelarde

         

        I indeed filled it in in that area as follows: