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 |