Purpose
This measure is used to understand the relative position of a product or customer within the portfolio based on revenue. It supports prioritization by helping business users focus on specific segments, such as top-performing items or low-ranked cases that may require attention.
Business Context
Revenue Rank expresses how a given product or customer compares to others in terms of revenue contribution. By using a percentile-based ranking, the measure provides a normalized view that is easy to interpret across portfolios of different sizes.
Definition
The measure calculates the percentile rank of revenue for the current row within the evaluated set. Values range from 0 (lowest revenue) to 1 (highest revenue).
Business Formula
Revenue Rank (Percentile) = (Rank − 1) / (Total Rows − 1)
Agent Expression
PERCENT_RANK(SUM(Revenue))