TotalRows = CountRows(‘Table’)
Author: Dax
Top Region Sales
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 ))
Sales LY
Sales LY =
Calculate ([Total Sales],
SAMEPERIODLASTYEAR(Dates[Date] ))