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.