Sort in descending order while Anchoring one item at bottom.

[amitjzaveri]

Hi,

I'm want to display brands in descending order, at the same time I want to display 'Brand_Other' always at the bottom.

Below is the output required.  

Brand_5     ->95
Brand_2    ->90
Brand_1    -> 70
Brand_4    -> 50
Brand_3    -> 40
Brand_Other    -> 60

Currently I'm getting order as Brand_5, Brand_2, Brand_1, Brand_Other, Brand_4, Brand_3.

Looking forward for above solution!

[amitjzaveri]

Thanks Stephen & Amit.

@Anonymous That's the closest solution I could think of as well. I was also thinking if we can do it via Dax Table on-the-fly however haven't tried that as that will add more complexity to the already complex output I have.

[Anonymous · Accepted solution]

Hi @amitjzaveri ,

You can sort the brands except Brand_Other first, and then add the last value to Brand_Other separately.

Best Regards,

Stephen Tao

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

[amitchandak]

@amitjzaveri , I doubt that is possible. As this is neither brand sort, not value sort.