Remaining Regions =
Calculate([Total Sales],
Filter (Regions,
RANKX(All, (Regions), [Total Sales]) >
Unique Of
Unique of =
DISTINCTCOUNT(‘Table'[Cities])
Within Range
Within Range =
VAR MinDate = MIN( FctoodDelivery[Date] )
VAR MaxDate = MAX( FctoodDelivery[Date] )
RETURN
IF(
AND(
Dates[Date] >= MinDate,
Dates[Date] <= MaxDate
),
TRUE(),
FALSE()
)
Top Ranking Pattern
Top Ranking Pattern =
VAR Top5 = RANKX(ALL(Locations[City]), [Total Sales], , DESC)
Return
IF( Top5 <= 5,
[Total Sales],
BLANK()
)
Sales Ranking (Regions)
Sales Ranking Regions =
ALL(Regions[Region]),
[Total Sales],,
ASC
)
Average Sales per Month
Average Sales per Month =
AVERAGEX(
Values(Dates[Month & Year]),
[Total Sales])
Average Transactions per Month
Average Transactions per Month =
AVERAGEX(
Values(Dates[Month & Year]),
[Total Transactions])
Average Transactions per Day
Average Transactions per Day =
AVERAGEX(
Values(Dates[Date]),
[Total Transactions])
% of Total (Regions) =
% of Total (Regions) =
DIVIDE([Total Sales],
Calculate([Total Sales], ALL(Regions) ))
% of Total Sales
% of Total Sales =
DIVIDE([Total Sales],
Calculate([Total Sales], ALL(People) ))
My Collection 