Forum Discussion

paulmacky's avatar
paulmacky
Regular Visitor
3 years ago

Rank ASC

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!

 

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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's avatar
      paulmacky
      Regular Visitor
      3 years ago

      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!!

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi paulmacky ,

        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.