Clustered Column Based on Criteria

Tweaked it to exclude rows from showing final rank:

Top 10 within range only =

var matchingrows = 

Filter(AllSelected(table), [YTD%]>= 0.45 && [YTD%]<= 1 && [YTD margin]>= 2000 && [YTD margin]<= 1000000)

var curr = [YTD%]

Return
if(
[YTD%]>= 0.45 && [YTD%]<= 1 && [YTD margin]>= 2000 && [YTD margin]<= 1000000

,RankX(matchingrows , [YTD%],,Desc, Skip)

,BLank()
)

Add this into the visual to check it works and then use it as a filter 🙂