Top Ranking Pattern =

VAR Top5 = RANKX(ALL(Locations[City]), [Total Sales], , DESC)

Return

IF( Top5 <= 5,

[Total Sales],

BLANK()

)

Sales Ranking Regions =

ALL(Regions[Region]),

[Total Sales],,

ASC

)

Top 5 Region Sales =

Calculate([Total Sales],

TopN (5, Regions, [Total Sales]))

Remaining Region Sales

Remaining Region Sales =

Calculate ([Total Sales],

Filter(Regions,

RANKX(ALL (Regions), [Total Sales]) > 5 ))