Buckets based on revenue

hi Julia2023 ,

Supposing you have a data table like:

try to plot a visual with a sum of [sales] column and a calculated column like:

Bucket = 
VAR RankValue =
RANKX(
    ALL(data[ID]),
    CALCULATE(SUM(data[sales]), ALLEXCEPT(data, data[ID])),
    ,DESC
)
VAR _totalrank = COUNTROWS(VALUES(data[ID]))
VAR BucketSize = DIVIDE(_totalrank, 3, 1)  
RETURN 
SWITCH(     
    TRUE(),     
    RankValue <= BucketSize, "Bucket 1",     
    RankValue <= 2 * BucketSize, "Bucket 2",       
    RankValue > 2 * BucketSize, "Bucket 3"   
)

it worked like below:

or directly write a calculated table like:

BucketTotal = 
VAR _table1 =
ADDCOLUMNS(
    data,
    "RankValue",
    RANKX(
        ALL(data[ID]),
        CALCULATE(SUM(data[sales]), ALLEXCEPT(data, data[ID])),
        ,DESC
    )
)
VAR _totalrank = COUNTROWS(VALUES(data[ID]))
VAR _bucketsize = DIVIDE(_totalrank, 3, 1)  
VAR _table2 =
ADDCOLUMNS(    
    _table1,
    "Bucket2",
    SWITCH(    
        TRUE(),    
        [RankValue] <= _bucketsize, "Bucket 1",    
        [RankValue] <= 2 * _bucketsize, "Bucket 2",      
        [RankValue] > 2 * _bucketsize, "Bucket 3"  
    )
)
VAR _table3 = 
ADDCOLUMNS(    
    SUMMARIZE(_table2, [Bucket2]),    
    "Revenue", 
    VAR _bucket =  [Bucket2]
    RETURN
    SUMX(
        FILTER(
            _table2,
            [Bucket2] = _bucket
        ),
    data[Sales]
    )
)
RETURN _table3

it worked like:

please find more info in the attachment. 

p.s. we can't treat measure value as categorical value and plot against other measures directly. In this case, bucket needs to be a calculated column.