Help with bottom N negative results

 

Ah, ok, my bad. It's evaluating the rank first, then filtering afterwards.

You'll need to apply the filter prior to each rank evaluation, something like this:

VAR _topItem =
    RANKX(
        //Filter table rank is evaluated over
        FILTER( ALL( Part_Sales[Item] ), [Total Sales] >= 0 ),
        [Total Sales],
        ,
        DESC
    )

 

Check whether this one works as required and, if it does, you'll need to apply a similar filter to each evaluation table in your rank variables.

 

Pete