Top10 + Others with duplicate values

[PowerRon]

Hi, 

In the past I was able to create a calculated column that made Top10+Others working

Sales Top10+Others =

VAR RankProductbySales = RANKX(All('Product'), [Sum Sales Quantity] ,,DESC)

RETURN

IF (RankProductbySales<=10,'Product'[productname], "Others")

That worked. But it worked because productname was unique in the table.
I recreated this in the attached pbix. Table Product_V1 connected to Sales and as you can see in the visual with column 'Product_V1' it gives the right result.

But I created a second version, table Product_V1. This reflects my current challenge, wehereby this Product_v2 is just very simplified.
The issue is that I now want to Rank by owner. But an owner can have multiple products. In other words, the owner is not unique in the product table.
How do I do this?

If you look at the left visual with column 'owner' it is rnked on product. But I want it to be ranked as shown in the left visual with column 'owner'. Whereby it contains three lines: Rob with 1125, John with 700 and Others with 1225.

https://www.dropbox.com/scl/fi/acmlmt4cvgmrd9ckj1en8/TopN-Others_2.pbix?rlkey=n5unb6h8hfq6uh8y1ulnbe... 

https://www.dropbox.com/scl/fi/05u3t9mwp73l9op2ys7gi/TopN-Others_2.xlsx?rlkey=04cjme3h457abgyjfpw2om... 

Hope someone can help.
@lbendlin 
@bhanu_gautam 

Regards Ron

[v-nmadadi-msft]

Hi @PowerRon,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[lbendlin · Accepted solution]

I would recommend you follow this approach instead

Filtering the top products alongside the other products in Power BI - SQLBI