Forum Discussion

Lobs's avatar
Lobs
Icon for Helper II rankHelper II
5 years ago
Solved

Rank using Columns filtered by Month

Hi All, 

 

So i am trying to create a column per metric that would rank our sites by month. Any care to give a sample on how i can do this? 

 

This is what i have in a measure 

Rank SC = RANKX(ALLSELECTED('CVA Data'[Site2]), [PTG Sprint Complete],,,Dense)
This was causing problems whenever i filter out the other sites in the visual i was using. 

 

 
Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi Lobs ,

     

    Consider following data and add an INDEX column to it as shown below in Query Editor:

     

    Now create a Rank column as follows:

     

    Now move this to the table visual as below and Rank calculated above:

     

    As you haven'e shared the expected output, Is this what you are expecting?

     

    Thanks,

    Pragati

     

5 Replies

    • Lobs's avatar
      Lobs
      Icon for Helper II rankHelper II
      5 years ago

      Sorry about that, here is the sample of the data im working on. Im just trying to rank them by Month, without using a measure. 

       

      MonthSiteMETRIC ScoreRank
      1/1/2020Loc 1 100 
      1/1/2020Loc 298 
      1/1/2020Loc 399 
      1/1/2020Loc 475 
      1/1/2020Loc 597 
      1/1/2020Loc 685 
      1/1/2020Loc 784 
      1/1/2020Loc 8100 
      1/1/2020Loc 950 
      1/1/2020Loc 1051 
      2/1/2020Loc 1100 
      2/1/2020Loc 298 
      2/1/2020Loc 399 
      2/1/2020Loc 475 
      2/1/2020Loc 597 
      2/1/2020Loc 685 
      2/1/2020Loc 784 
      2/1/2020Loc 8100 
      2/1/2020Loc 950 
      2/1/2020Loc 1051 
      • Pragati11's avatar
        Pragati11
        Icon for Super User rankSuper User
        5 years ago

        Hi Lobs ,

         

        Do you want to rank your rows on MONTH column?

        If yes, then on what other column - METRIC?

         

        Can you share the expected output also?

         

        Thanks,

        Pragati