How to Show Bottom 10 Items by Spend

Thanks for the reply from Ashish_Mathur  and sevenhills , please allow me to add some more information:

Hi  Anonymous ,

Here are the steps you can follow：

1. Create measure.

Flag =
var _rankasc=
RANKX(
    ALLSELECTED('Table'),CALCULATE(SUM([Rand])),,ASC,Dense)
var _rankdesc=
RANKX(
    ALLSELECTED('Table'),CALCULATE(SUM([Rand])),,DESC,Dense)
RETURN
IF(
    _rankasc<=10||_rankdesc<=10,1,0)

2. Place [Flag]in Filters, set is=1, apply filter.

3. Result:

Best Regards,

Liu Yang

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