RANK.EQ Function in Power Pivot Measure

Hi All

I have a Power Pivot report and have created a measure which calculates the percentage of sales from budget vs actual sales. The measure works fine. What I need to do is now to rank these % changes. My columns in PP are Division, Planed Budget, Actual Sales and my measured field which is called Pct Change.

When I want to create a new measure and use the Rank.EQ fucntion I keeo getting an erreor my formula sayd
=>RANK.EQ('Sales'[PCT Change],'Sales'[pct Change],0)
It keeps saying the second argument shpould be column refernce and I am not sure how to refernce the column.

Any help is apprreciate it.

If Sales[PCT Change] is a calculated field, you could convert it to a calculated column in order to facilitate what you are attempting.

However, if [PCT Change] is a calculated field and you wanted a calculated field for ranking, you could use: RANKX( ALL(Sales[Division]), [PCT Change])