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.