topic Re: RankX with Multiples values problem in DAX Commands and Tips

RankX with Multiples values problem

Anonymous — Thu, 02 Jul 2020 23:36:32 GMT

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!

Re: RankX with Multiples values problem

vivran22 — Fri, 03 Jul 2020 03:15:19 GMT

Hello Anonymous ,

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

Re: RankX with Multiples values problem

Anonymous — Fri, 03 Jul 2020 04:43:00 GMT

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?

Re: RankX with Multiples values problem

vivran22 — Fri, 03 Jul 2020 05:27:48 GMT

Anonymous

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