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

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: 

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

    The error is saying that can't find a table name Check-in ...try to put 'Check-in'

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

      Hi Vvelarde I was able to create this measure, but when I want to use it in a visualization, for expample for the response rate per month I get the following error:

       

      Error Message:

      MdxScript(Model) (1, 49) Calculation error in measure 'Check-Ins'[Response rate]: The function COUNT takes an argument that evaluates to numbers or dates and cannot work with values of type String.

      Stack Trace:

       

      Invocation Stack Trace:

       

      Activity ID
      46ee4405-bcff-4067-8fc7-ad0044f23eed

      Time
      Tue Oct 04 2016 09:10:47 GMT+0200 (Romance Daylight Time)

      Version
      2.38.4491.642 (PBIDesktop)

      Error Code
      rsDataShapeProcessingError

      OData Error Message
      Failed to execute the query.

       

      • v-caliao-msft's avatar
        v-caliao-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        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