Forum Discussion
Solved
RankX formula question
I am trying to rank sales leaders based on their average daily sales growth rate. The expression I am using seems to work, but any reason why the rankings would be arbitrary numbers instead of 1, 2, ...
Any chance you can provide sample data or PBIX file?
dmoney7612 what is Employee Id, can you remove that from the visual and check if it works, maybe it is passing the row filter context to the measure?
Now each ranking appears as "1". Are there any other tweaks needed to the expression?
Leader ranking = RANKX (ALLSELECTED('EC Hierarchy'[VP]),[ADS % Growth],,DESC,Dense)
Reference the main fact table column in the ALLSELECTED instead of the Hierarchy table column
Main fact table?
Sorry, I am assuming the EC hierarchy table is a dimension table. If it actually the fact table, try ALLSELECTED (EC Hierarchy)