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 ))
Of Useful Things
Top 5 Region Sales =
Calculate([Total Sales],
TopN (5, Regions, [Total Sales]))
Remaining Region Sales =
Calculate ([Total Sales],
Filter(Regions,
RANKX(ALL (Regions), [Total Sales]) > 5 ))