Top Ranking Pattern =
VAR Top5 = RANKX(ALL(Locations[City]), [Total Sales], , DESC)
Return
IF( Top5 <= 5,
[Total Sales],
BLANK()
)
Top Ranking Pattern
Of Useful Things
Of Useful Things
Top Ranking Pattern =
VAR Top5 = RANKX(ALL(Locations[City]), [Total Sales], , DESC)
Return
IF( Top5 <= 5,
[Total Sales],
BLANK()
)
