RANKX on Table Expression

Hi There, I have a smiple table: let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WclSK1YGRTmDSGUbGAgA=", BinaryEncoding.Base64), Compression.Deflate)),...

kongyuancn

4 years ago

Thank you lbendlin for your reply. But it doesn't work.

Values doesn't accept allselected inside, so I changed to distinct:

RankOnTableExp =
VAR DistinctTable = DISTINCT(ALLSELECTED('Table'[Data]))
VAR TableWithRank = ADDCOLUMNS(
DistinctTable,
"RANK",RANKX(DistinctTable,CALCULATE(MAX('Table'[Data])),,ASC)
)
VAR CurrentData = CALCULATE(MAX('Table'[Data]))
VAR CurrentDataRank = CALCULATE(MAXX(TableWithRank,[RANK]))
RETURN
CurrentDataRank

And the result is still wrong:

Forum Discussion

RANKX on Table Expression

Related content

RankX

Advanced Ranking (Rankx)

Rankx for two expressions

Help!!! Expression Error

Regular expression