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?
Sorry, I am assuming the EC hierarchy table is a dimension table. If it actually the fact table, try ALLSELECTED (EC Hierarchy)
That is what I had in my expression originally. See below: