Add 'Other' option to stacked column Graph

Hi CM_Mills ,

I created an example using this data:

Create a calculated column and write down as other if the product is less than 15% of the current country classification.

Column = 
VAR _sum1 =
    CALCULATE (
        SUM ( financials[ Sales] ),
        FILTER (
            ALL ( financials ),
            'financials'[Country] = EARLIER ( 'financials'[Country] )
        )
    )
VAR _sum2 =
    CALCULATE (
        SUM ( financials[ Sales] ),
        FILTER (
            ALL ( financials ),
            'financials'[Country] = EARLIER ( 'financials'[Country] )
                && 'financials'[Product] = EARLIER ( 'financials'[Product] )
        )
    )
RETURN
    IF ( _sum2 >= 0.15 * _sum1, 'financials'[Product], "Other" )

If the results don't match your expectations. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Clara Gong

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