Rankx break when used in Visual Filter

[Anonymous]

I have a Rankx funtion written as below;

Rank=
var __Top =

RANKX(FILTER(ALLSELECTED('PRODUCT Ref'[Value]),NOT(ISBLANK([Metric]))),[Metric],,DESC))
Return

IF(__Top <= VALUES(TopBottomNo[Value]), __Top , BLANK()) - I use this to show only top 10 ranks.

and it reurns as expected: 1,2,3,4,5,6,7,8,9,10

The problem is that, when I try to Filter matrix to "Show items when the value is not blank" I get the last number repeating twice which is incorrect; 1,2,3,4,5,6,7,9,10,10

Please can someone help with this?

[lbendlin]

Please provide sample data in usable format (not as a picture)