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.
_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!!
Thank you for your kind words. It's my pleasure to help.