rankx

  1. arnabmit

    Sum of bottom 20% values

    I was trying to get the sum of the bottom 20% values, then show it by year. However, the DAX returned the total value. Bottom 20% Values = VAR BV = ROUND(COUNTROWS(Sheet1) * 0.2,0) VAR DR = RANKX(ALL(Sheet1),CALCULATE(SUM(Sheet1[Value])),,DESC,Skip) RETURN IF(DR <= BV...
  2. R

    RANKX on date by group

    Hello ALL... My Goal: Find the most recent time that a student took a class. I have a table (called CLASSCOMPLETED) that contains the employreeID, CourseID, CompletedDate. I need to group by employee id, then group by courseID, then (in descending order of date) rank the classes. I think RANKX...
  3. E

    RANKX with COUNT/SUM function

    Hi all, Stuck with the following : Name Due Status Active Overdue Person 1 On Time 0 Person 1 Overdue 1 Person 1 Overdue 1 Person 2 Overdue 1 Person 2 Overdue 1 Person 2 Overdue 1 Person 3 Overdue 1 Person 3 Overdue 0 Person 3 On Time 0 The above is the table...
  4. T

    How do you do a RANKX Dax calculation properly??

    I am trying to build out a DAX RANKX formula that will rank Employee ID by Profit. Here is the formula I have today see below... However, this formula messes up when I start to layer in multiple dimensions into rows. Rank - DO Profit by Employee:=IF(ISBLANK([DO...
  5. T

    DAX RankX Troubleshooting with PowerPivot

    Hello, I am having issues using the RANKX function in my PowerPivot data model. I am trying to rank two different metrics by region, territory: sales and growth from last year. The sales rank works perfectly, but the growth rank seems to skip a rank when growth turns from positive to negative...
  6. zapppsr

    RANKX Calculated Column returning Circular Dependency

    Hi! I have a scenario here: I used RANKX to rank 13 "Regionais" based on the Column "Crescimento": MEASURE Ranking = RANKX ( ALLEXCEPT( fCrescimento ;fCrescimento[Ano]); CALCULATE ( MAX ( fCrescimento[Crescimento] ) ); ; ; DENSE ) So far so Good. I got what I wanted...
  7. S

    Apply Pivot table filter from results of another pivot table

    Hi I'm in need of some help. I've created a Pivot table based on a TOPn Rankx result. It provides me with a list of the top 10-25 items sold. I want to use the results from that table to filer the products details pivot table. I've been able to create VBA code but I can only filter the first...
  8. M

    RANKX and FILTER to only rank the first 3 months

    Hello, I have several months of data that I would like to rank only the first 3 months. I can rank all the months using RANKX but when I try to filter it down to just the first three months I either get an error or the entire column is 1. The equation below is my latest attempt but it...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top