Forum Discussion
Helper IIICalculating 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, with a different one for every person) and one with the submittance date of the form. This submittance date can also be blank. I would like to create a chart that gives me the response rate for the from/ So basically: Count of Id's / count of submittance dates (counting 0 when the submittance date is blank). I find this hard to do since the date is in a date/time format. Can anybody please help me?
Thanks in advance,
Matt
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
8 Replies
- Vvelarde
Community Champion
Matthias93This 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
