Rank Issue - Table vs Filter Results

Hi,

Thanks for your reply!

That makes sense — because ALLSELECTED() is preserving the external slicer context correctly in the table visual, but the issue is specifically that the filter pane evaluates measures in a different context than the visual itself.

So the problem is not really the ranking logic — it’s the evaluation context difference between visual rendering and filter evaluation in Microsoft Power BI.

A common workaround is to force the ranking to evaluate at the row granularity explicitly.

Try this pattern:

Rank (Top X Filter) =
VAR _Top =
    SELECTEDVALUE('Slicer'[Parameter])

VAR _CurrentProduct =
    MAX(Product[Product])

VAR _Rank =
    RANKX(
        ALLSELECTED(Product[Product]),
        CALCULATE(
            [Actual Sales $],
            KEEPFILTERS(Product[Product] = _CurrentProduct)
        ),
        ,
        DESC,
        DENSE
    )

RETURN
IF(_Rank <= _Top, 1, 0)

Why this helps

The important part is:

KEEPFILTERS(Product[Product] = _CurrentProduct)

This forces the measure to evaluate using the same product-row context even when Power BI computes it inside the filter pane.

Without this, the filter pane can evaluate the measure at a broader scope, causing the mismatch you’re seeing.

Another very stable alternative

Instead of filtering on the rank measure directly:

1. Create a separate rank measure:

Product Rank =
RANKX(
    ALLSELECTED(Product[Product]),
    [Actual Sales $],
    ,
    DESC,
    DENSE
)

1. Add it to the visual filter:

• Product Rank <= Selected Top X

This approach is usually more reliable than wrapping the rank inside an IF(1,0).

Important Note

Unfortunately, there are still some known inconsistencies with:

• ALLSELECTED()
• visual-level filters
• Top N logic
• slicer interactions

because Power BI internally evaluates filter measures before rendering the final visual context.

So even though the table result is correct, the filter pane may not naturally reuse that exact same evaluation context unless you force it as above

Hope this helps.

Thanks