+ Reply to Thread
Results 1 to 2 of 2

RANK.EQ Function in Power Pivot Measure

  1. #1
    Forum Contributor
    Join Date
    06-17-2014
    Location
    london
    MS-Off Ver
    365
    Posts
    398

    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.

  2. #2
    Registered User
    Join Date
    01-23-2015
    Location
    Texas
    MS-Off Ver
    2013
    Posts
    5

    Re: RANK.EQ Function in Power Pivot Measure

    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])

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Power Pivot rank cells if condition on column is met.
    By hyperlemon in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-18-2014, 04:39 AM
  2. Excel Power pivot measure
    By eajustin15 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-12-2013, 05:16 PM
  3. Power Pivot with multiple pivot charts using different pivot data
    By Paul-NYS in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-10-2013, 10:18 AM
  4. measure staff turnover by using pivot tables
    By mrsbear in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-09-2012, 05:47 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1