cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Community Champion
Community Champion

Re: Remove Duplicate Ranking

Hi @bhuprakash ,

 

You need to provide access to the file.

 

Regards,

HN

Highlighted
Helper IV
Helper IV

Re: Remove Duplicate Ranking

Hi @harshnathani , sorry for the botheration you faced.

Access is granted to you..Kindly let me know in case of any isssue

Highlighted
Community Champion
Community Champion

Re: Remove Duplicate Ranking

HI @bhuprakash .

 

 

Please find link to the file

 

https://drive.google.com/file/d/1ezsx_2BbNpCqkF3dku7aQ0jrLX5sQqVw/view?usp=sharing

 

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

Highlighted
Helper IV
Helper IV

Re: Remove Duplicate Ranking

Dear Harsh,

Thanks for your help.

Just I have only query. May be it is my silly question and may be not possible..but please clear my doubt.

As you shown in the chart, it is showing 11 retailers data as they are falling in below 11 rank.

but can I show only top 10 retailers as shown in below chart -

bi.png

Highlighted
Community Champion
Community Champion

Re: Remove Duplicate Ranking

HI @bhuprakash ,

 

The last 2 Sales Person have the same amount of Sales and that is why it is showingin the TOP 10 employees by Sales.

 

Incase you want to show 10 employees, you will need to break the ranks ( but this will not give a clear picture to the person whom you are sharing this dashboard) as both Rajesh and Rishant has 97 units of Sales.

 

 

Anyways incase you want to break ties.

 

Create a new measure

 

Randome = RAND()
 
 
Add [Randome] to Rank Measure
 
Rank Employee =
var a = RANKX(ALL(Sheet1[RetailerName]),[Quantity Sold per Employee]) + [Randome]
RETURN
a
 
1.jpg
 
 

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

 

View solution in original post

Highlighted
Helper IV
Helper IV

Re: Remove Duplicate Ranking

Thank you so much Harsh providing me the solution that I required.

But yes, you are right... my supervisor also saying the same thing that let the 11th person come in the dashboard because he also sold the same quantity as 10th one.

I am using your solution.. Thanks a lot to all 🙂 🙂

 

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors