Understanding Key Performance Indicators

What Is a KPI?

A key performance indicator (KPI) is a measurable value used to evaluate progress toward a business objective.

Examples include:

• Revenue achieved against a sales target.
• Customer retention rate.
• Average delivery time.
• Monthly profit margin.
• Number of new customers acquired.

A useful KPI connects a metric to a specific business goal.

Actual Values vs. Targets

A KPI often compares an actual result with a target.

For example, suppose a sales team has a monthly target of ₹500,000 and achieves ₹425,000.

The target achievement percentage is:

[
\text{Achievement %} =
\frac{\text{Actual Sales}}{\text{Sales Target}} \times 100
]

Therefore:

[
\frac{425000}{500000} \times 100 = 85%
]

The team has achieved 85% of its target.

You can create a DAX measure for this calculation:

Target Achievement % =

DIVIDE(

[Total Sales],

[Sales Target]

)

Format the measure as a percentage.

This example assumes that [Sales Target] is a suitable measure for the current reporting context.

Displaying KPI Status

KPI status can communicate whether performance is above, meeting, or below a target.

For example, a business might define these thresholds:

• At least 100% achievement: Target achieved.
• Between 90% and 99.99%: Near target.
• Below 90%: Below target.

The thresholds should reflect the organization's business rules. A lower delivery time, for example, may indicate better performance, so the status logic would differ from a revenue target.

Choosing Meaningful KPIs

Avoid measuring everything simply because data is available.

A useful KPI should be relevant to a business objective, measurable using reliable data, and understandable to its audience.

Also consider leading and lagging indicators. A lagging indicator measures an outcome, such as revenue achieved. A leading indicator may measure an activity that influences future results, such as the number of qualified sales opportunities.

Using both can provide a more complete picture of performance.