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 _AAndrade
Sure, I be more than happy to share that data, here is the screenshot from my Tableau's numerator and denominator for both Agency and Unit. I included behind the data for Arkansas Children's Northwest (denominator) and (numerator) so you can see what results I got in an excel file based on thos Tableau's calculations, maybe that would be hepful to write it differently in Power BI so we can get the same way of counting respondents based on their Agency selection, Unit Selection and the questions their asnwered and their respond was Strongly Agree and somewhat agree. I uploaded the result excel file in the Google drive and here is the link:
https://drive.google.com/file/d/1Kcgjn326KSc_VgI1zt0YHuJ9Ob1jsJUv/view?usp=drive_link
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.
_AAndrade I changed the following and then applied your solution and worked except a tweak in the table model in order for the Filters to filter the # of Enrollment this is the Model built that worked for my filters:
And then For denominator, I had a field called Satisfied Score that was conditional column that I built in tranform data section and I accidanlty chose Filtered Questions instead of Question Column, when I was editing that's why when I swited my partners, the data was coming back as Null or blank. THANK YOU SO MUCH for your continous help, solutions and not giving up and not ignoring it!! I will accept your solution so hopefully you Rank will go higher and higher you certainly deserve it!!
_AAndrade Thank you so much! I will follow these steps right away! Is there a way you can send this edited/updated Power BI file back for my reference please?
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 .
Thank you for your kind words. It's my pleasure to help.