For 3rd largest:
With TOPN:
With RANKX:PHP Code:
MINX(
TOPN( 3, SUMMARIZE( Table1, Table1[Units] ), Table1[Units], DESC ),
[Units]
)
RegardsPHP Code:
VAR MyTable =
SUMMARIZE(
Table1,
Table1[Units],
"Rank", RANKX( ALL( Table1 ), Table1[Units] )
)
RETURN
MAXX( MyTable, IF( [Rank] = 3, [Units] ) )
Bookmarks