Stratifying into 1/3rds Formula

Sample data would be great. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Probably use RANKX to get a ranking and then you can segment that into thirds. Diffifult to be more specific.

Anonymous 

One way is percentile - https://community.powerbi.com/t5/Desktop/Calculating-the-percentile-for-a-set-of-data/td-p/250581

Second is the percent of running total,

Like

measure =
var _1 = divide(calculate(table[revenue],filter(all(table),table[revenue]<=table[revenue])),calculate(table[revenue],all(table)))
return
if(_1<=.33 ,15, if(_1< .66,10,5))

Hi Anonymous ,

I created a simple sample that you could try and check if it is what you want.

They are all measures.

Cumulated Revenue = 
CALCULATE (
    SUM ( 'Table'[Revenue] ),
    FILTER ( ALL ( 'Table' ), 'Table'[Business] <= MAX ( 'Table'[Business] ) )
)

Cumulated Percentage =
DIVIDE (
    [Cumulated Revenue],
    CALCULATE ( SUM ( 'Table'[Revenue] ), ALL ( 'Table' ) )
)

ABC Class = 
SWITCH (
    TRUE (),
    [Cumulated Percentage] <= 0.33,5,
    [Cumulated Percentage] <= 0.66,10,
   15
)

For more details, Please see the attchment. If I misunderstanding, you could reference the DAX patterns blog to have a try.

ABC Classification 

 

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.