Create an index measure in a matrix

[Jeremy19]

Hello,

I have a seemingly simple problem that I can't seem to solve. I want to add an index measure to a matrix.

To simplify, my data looks like this:

id	Minutes
A	10
A	15
A	20
B	5
B	15

and I have a matrix filtered by id=A with only the minutes column. 

I have created a measure :  

Measure = MIN(Feuil1[Minutes])

and an index measure :

Rank = RANKX(ALLSELECTED(Feuil1[Minutes]),[Mesure],,DESC)

I obtain this result :

But I would like to have the reverse order, but change DESC to ASC, I obtain :

Do you know how to calculate this rank correctly?

Thanks

[ThxAlot]

A more generic solution,

[hackcrr · Accepted solution]

Hi, @Jeremy19 

The main reason why you get wrong sorting result under ASC sorting is that the current rank is also affected by id=B, e.g. 10 should correspond to a rank of 1.

You should change your DAX expression to look like this:

Rank = RANKX(ALLSELECTED('Feuil1'),[Mesure],,DESC)

 The DAX used in my tests is as follows:

rank = 
RANKX(ALLSELECTED('Table'),[Measure],,ASC,Dense) 

This DAX does a good job of returning the correct ranking results:

Best Regards,

hackcrr

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[qqqqqwwwweeerrr]

Hi @Jeremy19 

Is this what your expectation is 

i have used this measure: 

Rank = RANKX(ALLSELECTED('Table'[id],'Table'[Minutes]),[Measure],,ASC,Dense)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem

Regards