Rank using Columns filtered by Month

[Lobs]

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. 

[Pragati11]

Hi @Lobs ,

Can you add more details to your question please like screesnhots?

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati

[Lobs]

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. 

Month	Site	METRIC Score	Rank
1/1/2020	Loc 1	100
1/1/2020	Loc 2	98
1/1/2020	Loc 3	99
1/1/2020	Loc 4	75
1/1/2020	Loc 5	97
1/1/2020	Loc 6	85
1/1/2020	Loc 7	84
1/1/2020	Loc 8	100
1/1/2020	Loc 9	50
1/1/2020	Loc 10	51
2/1/2020	Loc 1	100
2/1/2020	Loc 2	98
2/1/2020	Loc 3	99
2/1/2020	Loc 4	75
2/1/2020	Loc 5	97
2/1/2020	Loc 6	85
2/1/2020	Loc 7	84
2/1/2020	Loc 8	100
2/1/2020	Loc 9	50
2/1/2020	Loc 10	51

[Pragati11]

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

[Lobs]

Yes, by month using the Metric Column. The out on these columns will be used on the KPI indicator visual which will be filtered by Site. 

[Pragati11 · Accepted solution]

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