RankX with Multiples values problem

[Efsteps]

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!

[vivran22]

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]

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 · Accepted solution]

@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