Calculating Customer Satisfaction Score (CSAT) in Power BI

Overview

Customer Satisfaction Score (CSAT) has become one of the most widely adopted metrics for operational and customer‑experience teams because of its ability to capture real‑time sentiment at the exact moment a customer interacts with a product, service, or support channel. Organizations rely on CSAT to understand whether day‑to‑day experiences are meeting expectations and to quickly identify where friction is emerging across the customer journey.

In modern analytics environments, CSAT is more than a survey metric - it’s a continuous feedback loop that informs service recovery, product improvements, and frontline performance. When tracked consistently, it helps teams spot patterns such as declining satisfaction after specific touchpoints, variations across regions or agents, or the impact of new initiatives. Because of its simplicity and directness, CSAT is often the first metric executives look at when assessing the health of customer interactions.

So, what is Customer Satisfaction Score (CSAT)?

A customer satisfaction score (CSAT) is a metric that tells you what percentage of your customers report being satisfied with a product, service, or interaction. It’s typically gathered by asking a simple question such as “How satisfied were you with your experience?” and letting customers rate it on a scale – usually 1–5, 1–7, or 1–10 before being converted into a percentage that represents the share of “happy” customers.

CSAT (%) = (Number of positive responses ÷ Total responses) × 100

What counts as a “positive” response depends on the scale used:

• 1–5 scale: Ratings of 4 and 5 are considered satisfied.

• 1–10 scale: Ratings of 8–10 are considered satisfied.

• 1–7 scale: Ratings of 5–7 are considered satisfied.

Calculating CSAT in Power BI

Create a calculation computing the positive responses (satisfied responses) as shown below.

Next, compute CSAT% as follows.

Build Visuals

1. CSAT Card

Create a simple KPI showing the current CSAT value.

2. Compare CSAT ratings by other groups

Show performance by other categories e.g., Branches for my case.

3. Compare CSAT ratings by Time

Show performance overtime.

Conclusion

Calculating Customer Satisfaction Score (CSAT) in Power BI does more than produce a single percentage - it creates a living metric that teams can explore, segment, and act on. By shaping the data model correctly, defining clear DAX measures, and presenting the results through intuitive visuals, CSAT becomes a practical decision‑making tool rather than a static survey output. Power BI’s interactivity allows stakeholders to drill into specific channels, regions, agents, or touchpoints, revealing the underlying drivers of satisfaction and highlighting where improvements will have the greatest impact. When embedded into regular reporting cycles, a well‑designed CSAT dashboard helps organizations stay close to customer sentiment, respond quickly to emerging issues, and continuously refine the experiences that matter most.

If you like the work we do and would like to work with us, drop us an email on our contacts page and we’ll reach out!

Thank you for reading!!