Re: Rank ASC

paulmacky · ‎10-27-2022

Hi! I want to make a ranking in ASC order and that when filtering by League, the ranking is updated with the filters.

When I don't put ASC in the code, when filtering if the Rnaking comes out ordered:

But when adding to the ASC code, so that I order it in ascending order, the ranking filtered by league is not left, but when filtering the ranking number appears globally. How can I do, so that when filtering by League, the ranking appears ordered 1,2,3,4,5... as it appears to me when I do not put ASC?

Thnx!

Anonymous · ‎10-27-2022

Hi @paulmacky ,

I have created a simiple sample, please refer to it to see if it helps you.

Create a measure.

Measure2 =
RANKX (
    FILTER (
        ALL ( 'Table' ),
        'Table'[Min/centros] >= SELECTEDVALUE ( 'Table'[Min/centros] )
    ),
    CALCULATE ( SUM ( [Min/centros] ) ),
    ,
    DESC
)

Or create a column.

Column =
RANKX (
    FILTER ( 'Table', 'Table'[Min/centros] >= EARLIER ( 'Table'[Min/centros] ) ),
    [Min/centros],
    ,
    DESC
)

If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information .

Best Regards

Community Support Team _ Polly

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

paulmacky · ‎10-28-2022

Hi @Anonymous ! Thanks for your reply, but I still can't solve the problem.

I need this measure that I have created, when filtering it in "Liga" by "1ª Federación", "Argentina" or "Segunda División" to appear like this:

Because in the created measure, if I don't put "ASC" it does the filtering, but when I put "ASC", since I want that column to have a ranking in ascending order, it doesn't do the ranking for me when filtering.

Without "ASC", the ranking with the filter is ok, but it is in descending order, and I need the same but in ascending order. That is, by ordering the "Min/Centros al área" column from lowest value to highest value with the filter on "Liga" of "Segunda División", I want the "ranking" to appear the same as in the photo just above.

Thanx!!