Forum Discussion
Karentang
9 years agoRegular 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
| CostCode | Ytd Total | FinancialYear | Rank |
| 104 | 3953 | 2017 | 2 |
| 105 | 17070 | 2017 | 2 |
| 106 | 52270 | 2017 | 2 |
| 107 | 46126 | 2017 | 2 |
No RepliesBe the first to reply