Forum Discussion

eyeball's avatar
eyeball
Frequent Visitor
9 years ago
Solved

Using Rank in a table

Hi, I'm trying to get to grips with the RANK function but I seem to be having a bit of trouble getting it to work.  I have a table that stores opportunities for both contacts and companies and I wou...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    eyeball

     

    hi, please try this: (Is a Sean version with little changes)

     

    Ranking =
IF (
    FIRSTNONBLANK ( Table1[AccountId], Table1[AccountId] ) <> BLANK (),
    RANKX (
        FILTER ( ALL ( Table1 ), Table1[AccountId] <> BLANK () ),
        CALCULATE ( SUM ( Table1[Value] ) )
    )
)

     

eyeball's avatar
eyeball
Frequent Visitor
9 years ago

Hi Sean,

Many Thanks for this, it looks good!  The only problem I've got now is that the Id is actually a guid (sorry, should have mentioned that) so the min function is seeing it as a string...

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

eyeball

 

hi, please try this: (Is a Sean version with little changes)

 

Ranking =
IF (
    FIRSTNONBLANK ( Table1[AccountId], Table1[AccountId] ) <> BLANK (),
    RANKX (
        FILTER ( ALL ( Table1 ), Table1[AccountId] <> BLANK () ),
        CALCULATE ( SUM ( Table1[Value] ) )
    )
)