topic Re: RANKX on Multiple Criteria Including Manager, Months, Monthly Results in DAX Commands and Tips

RANKX on Multiple Criteria Including Manager, Months, Monthly Results

qazimobin — Wed, 02 Aug 2023 11:13:54 GMT

Hi everyone,

I want to use RANKX function to rank managers performance based on monthly % achievement. I want to rank 14 managers first for January then again for February and so on.

Please guide how to achieve this.

Re: RANKX on Multiple Criteria Including Manager, Months, Monthly Results

eliasayyy — Wed, 02 Aug 2023 11:38:35 GMT

hello qazimobin

please refer to the calculated column

Ranking = rankx(filter('Table', 'Table'[Months] = earlier('Table'[Months]) ), 'Table'[% Ach],,desc, dense)

if it solved your porvlem please acept as solution and leave a thumbs up

Re: RANKX on Multiple Criteria Including Manager, Months, Monthly Results

qazimobin — Wed, 02 Aug 2023 11:47:35 GMT

eliasayyy thank you very much dear. Wonderful to see my ranking working absolutely fine. Thumbs up to you for quick resolve.

Re: RANKX on Multiple Criteria Including Manager, Months, Monthly Results

eliasayyy — Wed, 02 Aug 2023 12:48:19 GMT

Glad to be able to help have a nice day