Forum Discussion
Satisfaction Rate Calculation In Power BI (Likert Scale)
Hi,
Finally, I'm getting the same values as you.
The final result is this:
Measures:
As you can see in the matrix for Arkansas you have 34 rows but you only consider 24. With your example I found that you only count if the column "Satisfied Socores" is different to "" (empty), therefore I used this criteria to do my denominator. In your first mensage you have a different criteria using "Category"="CA" but I didn't find any row with that information.
In my solution I'm using your first pbix and only makes some changes on the relations. The final model is this:I hope this could solve your problem.
Hi,
Finally, I'm getting the same values as you.
The final result is this:
Measures:
As you can see in the matrix for Arkansas you have 34 rows but you only consider 24. With your example I found that you only count if the column "Satisfied Socores" is different to "" (empty), therefore I used this criteria to do my denominator. In your first mensage you have a different criteria using "Category"="CA" but I didn't find any row with that information.
In my solution I'm using your first pbix and only makes some changes on the relations. The final model is this:
I hope this could solve your problem.
Thank you so much _AAndrade this gave me the exact results for satisfaction rates, numerator numbers and denominator numbers are all showing up correctly. I feel that you know this dataset so well and would it be possible to tell me why after a few changes I did in the data model changes when now that I go to my Response Rate tab, my Enrollment number doesn't change and now that the Satisfaction Rate number are correct the # of Enrollment and REsponse Rate is not calculating right. Any solution for that? I change everything and I saved over it so I can't go back but here are the screen shots with the right number of response and Enrollment. You mentioned in your last response you couldn't find the Category called 'CA', the category for this survey would be called 'CLAG' not sure if that would help with anything that is happenning here. Also, how can I have Satisfaction Result for a different Parnter, if I change the Partner from HUY to MDUY all the denominator values and Satisfaction Rate % changes to zero.
This shows Mercy's Hospital # of respondent and # of enrolled students and the Response Rate%
This shows the # of respondent and # of enrollment for Med/Surg unit in Mercy hospital
I had these numbers calculations right and it's under Response Rate page tab and this is what's happenning right now: Since the number of Enrollment is not being counted correctly it's messing up the Response Rate Calculation. Currenlty this is what's showing up in Power BI
I would appreciate it if you can tell me what happend and why did this happend .