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!
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.
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!!
How can I share the pbix file here? Since I try to attach it to the message but this appears:
