Forum Discussion

CREsearch's avatar
CREsearch
Frequent Visitor
6 years ago
Solved

Return nth ranked value based on criteria

In the below dataset I have a column that ranks the order/position of a value within a grouping. I'm trying to find a dax function that will allow me to return the nth largest value based within a gi...
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi CREsearch ,

    Try this:

    SwapRank 2 = 
RANKX (
    FILTER ( 'Table', 'Table'[Address] = EARLIER ( 'Table'[Address] ) ),
    'Table'[Rank],
    ,
    DESC,
    DENSE
)

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

CREsearch's avatar
CREsearch
Frequent Visitor
6 years ago

I'm getting a circular dependency error for some reason. Note that it has to be a custom column I believe and not a measure as I need to use it for an axis in a bar chart. 

Icey's avatar
Icey
Icon for Community Support rankCommunity Support
6 years ago

Hi CREsearch ,

Try this:

SwapRank 2 = 
RANKX (
    FILTER ( 'Table', 'Table'[Address] = EARLIER ( 'Table'[Address] ) ),
    'Table'[Rank],
    ,
    DESC,
    DENSE
)

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

  • CREsearch's avatar
    CREsearch
    Frequent Visitor
    6 years ago

    Yes, works like a charm! Thank you!

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      6 years ago

      Hi,

      If my reply helped, please mark it as Answer.