Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Lobs
Helper II
Helper II

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. 

 

 
1 ACCEPTED SOLUTION

Hi @Lobs ,

 

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

Pragati11_0-1601892987743.png

 

Now create a Rank column as follows:

Pragati11_1-1601893021723.png

 

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

Pragati11_2-1601893082896.png

 

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

 

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

View solution in original post

5 REPLIES 5
Pragati11
Super User
Super User

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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 

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

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

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. 

 

 

Hi @Lobs ,

 

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

Pragati11_0-1601892987743.png

 

Now create a Rank column as follows:

Pragati11_1-1601893021723.png

 

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

Pragati11_2-1601893082896.png

 

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

 

Thanks,

Pragati

 

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.