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.
I don't have data with [Category]="CA". Let's concentrate in one Agency firt.
For Mercy Hospital we have this responses:
First measure is distinct count of all responses and "New Promoter" it's my new measure than only counts if the responses is "Strongly Agree", "Somewhat Agree", or "Not Applicable".
How I should do to calculate the Satisfaction Rate % ?
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