Sorting Calculated Column

Hi,

One of ways to achieve this is creating a new column for the sorting purpose.

ARR bands sort CC =
SWITCH (
    TRUE (),
    tablename[columnname] < 10000, 1,
    tablename[columnname] >= 10000
        && tablename[columnname] < 49999.99, 2,
    tablename[columnname] >= 49999.99
        && tablename[columnname] < 99999.99, 3,
    tablename[columnname] >= 100000, 4
)

Try to create one more calculated column like above, and sort the  [ARR bands] column by the above column.

Thanks.