cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Karentang
Regular Visitor

RANKX return wrong value

I 'summarize' a table with cost centre and Ytd value. Then I creat a measure:

Rank = rankx(YtdActualSummary,YtdActualSummary[Ytd Total],1). but the ranking is wrong. Could you please tell me what went wrong? Thanks

CostCodeYtd TotalFinancialYearRank
104395320172
1051707020172
1065227020172
1074612620172
0 REPLIES 0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.