Forum Discussion

Efsteps's avatar
Efsteps
Frequent Visitor
6 years ago
Solved

RankX with Multiples values problem

Hi everyone, i'm trying to get a rank from this database in this report: click here to see I'm trying with this two measures: This one is make to made a filter ignoring 0 values i'm not sure i...
Need Help
  • vivran22's avatar
    vivran22
    6 years ago

    Efsteps 

     

    Please ignore the previous post. Following are the required measures:

     

    Rank Answered Asc = 
IF(
    HASONEVALUE(Sheet1[Name]),
RANKX(
    ALLSELECTED(Sheet1[Name]),
    [Avg Answered Time],,ASC
    )
)

Rank Answered Asc Skip = 
IF(
    HASONEVALUE(Sheet1[Name]),
RANKX(
    ALLSELECTED(Sheet1[Name]),
    [Avg Answered Time],,ASC,Dense
    )
)


Rank Answered Desc = 
IF(
    HASONEVALUE(Sheet1[Name]),
RANKX(
    ALLSELECTED(Sheet1[Name]),
    [Avg Answered Time],,DESC
)
)

Rank Answered Desc Skip = 
IF(
    HASONEVALUE(Sheet1[Name]),
RANKX(
    ALLSELECTED(Sheet1[Name]),
    [Avg Answered Time],,DESC,Skip
    )
)

     

    It is ranking as accuretly

     

    Cheers!
    Vivek

    If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
    If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

    Blog: vivran.in/my-blog
    Connect on LinkedIn
    Follow on Twitter

Efsteps's avatar
Efsteps
Frequent Visitor
6 years ago

Appreciated your respoonse but the rank isn't correct based on the average every person as you see in your image some values haven't the right top position i've tried by myself and has the same results, is in fact an error that i have before i developed the posted formulas.

Any idea how to solve this?

vivran22's avatar
vivran22
Community Champion
6 years ago

Efsteps 

 

Please ignore the previous post. Following are the required measures:

 

Rank Answered Asc = 
IF(
    HASONEVALUE(Sheet1[Name]),
RANKX(
    ALLSELECTED(Sheet1[Name]),
    [Avg Answered Time],,ASC
    )
)

Rank Answered Asc Skip = 
IF(
    HASONEVALUE(Sheet1[Name]),
RANKX(
    ALLSELECTED(Sheet1[Name]),
    [Avg Answered Time],,ASC,Dense
    )
)


Rank Answered Desc = 
IF(
    HASONEVALUE(Sheet1[Name]),
RANKX(
    ALLSELECTED(Sheet1[Name]),
    [Avg Answered Time],,DESC
)
)

Rank Answered Desc Skip = 
IF(
    HASONEVALUE(Sheet1[Name]),
RANKX(
    ALLSELECTED(Sheet1[Name]),
    [Avg Answered Time],,DESC,Skip
    )
)

 

It is ranking as accuretly

 

Cheers!
Vivek

If it helps, please mark it as a solution. Kudos would be a cherry on the top 🙂
If it doesn't, then please share a sample data along with the expected results (preferably an excel file and not an image)

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter