Forum Discussion
Satisfaction Rate Calculation In Power BI (Likert Scale)
- 2 years ago
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, I'm trying to help you but I can't understand what you really want to do in your calculations.
Please give me same pictures with the correct results and I will try to do it in power bi.