Special logic for sorting a table

[rainerpowerbi]

Hi,

I created a table and if I select TOP 3-Products I receive following table:

If I select TOP 5-Products I receive following table:

My question:
Is there a a possibilty sorting Procuct-Column
- after Measures_Sales (descending)
- WITH THE EXECPTION of ROW WITH "OTHER": this row always shall be BELOW in the table (independ of measures-amount)

Kind regards

Rainer

[Dinesh_Suranga]

@rainerpowerbi 

Hi,

1 Click more option (Three dots)

2 Click Sort By

3 Select your mesure.

Thank you