Forum Discussion
Calculating the submittance rate
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
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.
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
This worked perfectly, thank you so much