RANKX excluding a value

Hi,

I do not know how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

I tried to use WINDOW DAX function and RANK DAX function in the measures.

Sales total = SUM(sales[sales])

WINDOW function (DAX) - DAX | Microsoft Learn

RANK function (DAX) - DAX | Microsoft Learn

Top 10 sales except C03 = 
CALCULATE (
    [Sales total],
    KEEPFILTERS (
        WINDOW (
            1,
            ABS,
            10,
            ABS,
            FILTER ( ALL ( customer[customer_name] ), customer[customer_name] <> "C03" ),
            ORDERBY ( [Sales total], DESC )
        )
    )
)

Rank = 
VAR _result =
    RANK (
        SKIP,
        FILTER ( ALL ( customer[customer_name] ), customer[customer_name] <> "C03" ),
        ORDERBY ( [Sales total], DESC )
    )
RETURN
    IF ( _result <= 10, _result )