Purpose
This measure is used to understand the relative position of a product or customer within the portfolio based on profitability. It helps business users focus on specific segments, such as the most profitable products or customers, as well as lower-performing cases that may require corrective actions.
Business Context
Profit Rank expresses how a given product or customer compares to others in terms of profit contribution. By using a percentile-based ranking, the measure provides a normalized view that is easy to interpret across portfolios of varying sizes.
Definition
The measure calculates the percentile rank of profit for the current row within the evaluated set. Values range from 0 (lowest profit) to 1 (highest profit).
Business Formula
Profit Rank (Percentile) = (Rank − 1) / (Total Rows − 1)
Agent Expression
PERCENT_RANK(SUM(GrossMargin))