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: 

    • 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.