Forum Discussion
DAX Challenge
Hi All, I have the following sales table where I need to find annual ranking of salesperson but there is a small complexity.... The ranking depends not only on number of annual car sales by t...
Anonymous , I chanced on this video and improved the measure; you might want to refer to it as well,
Annual Ranking = VAR __delta = MAX ( Sales[Date of Joining] ) RETURN RANKX ( ALLSELECTED ( Sales[EMPLOYEE_ID] ), CALCULATE ( SUM ( Sales[Annual Car Sales] ) * __delta + SUM ( Sales[Date of Joining] ), ALLEXCEPT ( Sales, Sales[EMPLOYEE_ID] ) ) )
AlexisOlson
Super User
Super UserWhen ranking, is the employment period only used for tie-breaking?
yes indeed only for tie breaking..sorry should have been more clear ...