Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
stsau
Frequent Visitor

identify rank number for topN% of a measure

I am testing pareto principle and calculating the top N% of revenue and the underlying responsible customers.
Customer are being ranked by amount of their rev value:

Revenue Rank =CALCULATE(
RANKX(ALL(RevData[enduser_cust_name]); [Total Revenue FY 18]; ;DESC);
ALLSELECTED(RevData[Portfolio])
)

Now I want to compare the numbers of all (unique) customers with the number of customers that make up N% of revenue, so I get the customers that are making up the N% of revenue:
( N% can be selected by What-If slicer 'Revenue %'[Revenue % Value] )
 
Top R% Customers =
IF(ISBLANK([Total Revenue FY 18]) ;
   BLANK();
     IF(RANKX(ALL(PRevData); [Total Revenue FY 18]; ;DESC) < (CALCULATE( [Unique Revenue        Customers];ALL(RevData) ) * ('Revenue %'[Revenue % Value]/100) );
[Total Revenue FY 18];
BLANK()
)
 
)pbi.PNG
 
 
 
 
 
 
 


its all working ok, [Top R% customer] column is showing blanks, once selected N% revenue is reached.
 
However I am not able to get to identify the rank, that corresponds to [Top R% customer] becoming blank, which is the number of customers responsible for N% of revenue.
Searching the forum I see posts that relate to maxx(column), however this is a measure + its only a subset of the underlying table, so countrows would not work either.
Any idea appreciated.
0 REPLIES 0

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.