Forum Discussion
mb0307
Responsive Resident
Responsive ResidentRanking - negative or positive
Hi all, As shown in the example below, I would like to rank the companies by sales variance. Result should show Top 5 ranking by biggest variance number regardless if it is a -ve or +ve number. ...
Use the ABS function to render all values positive and then use that in the RANKX measure. (Or new column)
This blog post may help (if you wish to display the actual rank):
Rankx(all(Table[compnay]), calculate(abs(sum(table[sales variance]))),,asc,dense)
by adding ABS function it gives the desired output.
Thanks
