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 if is doing it well:

MeasureAverageAnswered = CALCULATE(SUM(Sheet1[Answered]),
FILTER(Sheet1,Sheet1[Name] = MAX(Sheet1[Name])))


And the rank measure that i made is this one below:


Rank = RANKX(ALL(Sheet1[Answered]),[MeasureAverageAnswered],,DESC,Dense)

 

As you see on the image the rank measure only brings me number 1 value instead a rank


Can someone Help me with this?

 

the files are on the top of this post

Thank You Very much for reading!

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

3 Replies

  • vivran22's avatar
    vivran22
    Community Champion
    6 years ago

    Hello Efsteps ,

     

    You may try this:

     

    Avg Answered Time = AVERAGE(Sheet1[Answered])

Rank Answered Time1 = 
IF(
    HASONEVALUE(Sheet1[Name]),
RANKX(
    (Sheet1),
    [Avg Answered Time]
 )
)


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

     

    Result:

     

     

    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