cancel
Showing results for
Did you mean:
Helper III

## Nested sorting

Hi all,

I'm struggling with something seamingly easy. I want to show the top 20 opportunities by sales \$ per region. As per attached below, when I filter the TOP N opportunities (count) it filters all the opportunities based on the top 30 sales but how could I do a nested sorting to show teh top 30 opps by sales per region?

1 ACCEPTED SOLUTION
Microsoft

Hi @harrinho,

I think we just need a region slicer and a filter of top N = 5. Have look at the picture. It's similar with this scenario. In the upper part, the top 5 colors will show up if we choose a brand. In the bottom of the picture, if we want to show all the top 5, it would be not that clear.

BTW, it's a measure in the bottom part.

```4Measure =
RANKX ( ALL ( 'Product'[Color] ), CALCULATE ( SUM ( Sales[Quantity] ) ) )```
```5Measure =
IF ( [4Measure] <= 5, [4Measure], BLANK () )```

Best Regards!

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Microsoft

Hi @harrinho,

Could you please mark the proper answer if it's convenient for you? That will be a help to others.

Best Regards!
Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Microsoft

Hi @harrinho,

I think we just need a region slicer and a filter of top N = 5. Have look at the picture. It's similar with this scenario. In the upper part, the top 5 colors will show up if we choose a brand. In the bottom of the picture, if we want to show all the top 5, it would be not that clear.

BTW, it's a measure in the bottom part.

```4Measure =
RANKX ( ALL ( 'Product'[Color] ), CALCULATE ( SUM ( Sales[Quantity] ) ) )```
```5Measure =
IF ( [4Measure] <= 5, [4Measure], BLANK () )```

Best Regards!

Dale

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

Announcements

#### Happy New Year from Power BI

This is a must watch for a message from Power BI!