Rankx Measure returns different values when using a filter

[Anonymous]

I am using the following measure to rank a store within its region based on its % to goal:

% to Goal Rank = rankx(FILTER(ALL('Look ups - Store'[Region], 'Look ups - Store'[Store]), 'Look ups - Store'[Region]=MAX('Look ups - Store'[Region])), [% to Goal])

It works correctly without using a slicer(first image), but it shows different results when using a slicer (second image). Any ideas why?

[v-yuta-msft · Accepted solution]

@Anonymous ,

You can try 'ALL' a 'Table' instead of ‘ALL’ a 'Column'.

% to Goal Rank =
RANKX (
    FILTER (
        ALL ( 'Look ups - Store' ),
        'Look ups - Store'[Region] = MAX ( 'Look ups - Store'[Region] )
    ),
    [% to Goal]
)

Community Support Team _ Jimmy Tao

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

[Anonymous]

Thanks @v-yuta-msft, this is working perfectly now! 

[Vvelarde]

@Anonymous 

Hi. what happens if your use ALLSELECTED instead of ALL.

Let me know the result

Regards

Victor

[Anonymous]

Hi @Vvelarde, thanks for your reply. 

How do I use ALLSELECTED with two inputs?