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.
To calculate the Satisfaction Rate % we need to treat the new promoter as the numerator and divide it by SUM # of RESP (since # of RESP is the count of the respondents) Does that make sense? I do have # of RESP as a measurment and as a column. I believe my issue is in the numerator (Promoter) formula.
I changed my model so I will update the file on google doc as well this is the new model:
Hi,
Please check if any satisfaction rate is what you're looking for:
Based on what I have in Tableau to compare these are the correct results:
The highlighted blue is Agency and the table on the right of it are the Units for that particular Agency's Satisfaciton results. Does this help at all. I truly appreciate you helping me.
_AAndrade I have also updated my table connections and I uploaded the new file, incase you need to take a look at the new file, I was adviced to update my connections and was told that what I had wasn't looping correctly.
Please show me the right numbers do you have (numerator and denominator) to get this percentages
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