Rank Column For my Value

[YasirBilal]

Hello Everyone

id	employee id	task id	employee name	category	status	points
1	employee1	1	name1	category1	complete	100
2	employee2	3	name2	category1	complete	300
3	employee3	2	name3	category1	complete	500
4	employee1	2	name1	category1	complete	200
5	employee1	1	name1	category1	complete	100

this is example of dataset which i'm working on what i want to achive is i need to make a column for rank whoever have most points get rank 1 and so on 

i have 4 visual with different data of employee what i have to do is to find rank 1 employee and then filter all the visual base on that rank

what i'm trying to do is show the data of top employee of month and that rank based on his points whoever have most of points get rank 1

ID column is optional if needed i can remove

if someone can help me how to rank employee by points will be appreciate

Thank You

[parry2k · Accepted solution]

@YasirBilal read this blog post on ranking and apply it to your model.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[parry2k · Accepted solution]

@YasirBilal then you should rank based on the sum and use it as a measure, check this post how you can do that.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[YasirBilal]

Sorry for late reply 

but problem is i need a column i don't need measure becasue with measure i'm not able to filter other of my visual that's show only data to rank 1 employee that's why i need column but with rankx issue is each row getting rank number and i have 1 employee with multiple points 

you think i need to create another sheet with total point of each employee then use rankx 

[parry2k · Accepted solution]

@YasirBilal read this blog post on ranking and apply it to your model.

Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions  I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[YasirBilal]

thanks for reply but is there any way to add points of 1 employee and then use rankx 

means 1 employee have more than 1 task complete so when i filter rank 1 only show 1 task he complete but what i try to do is add all those task point and then that employee get rank 1 

like

employee 1    100

employee 1    200

employee 1    400

that's total 700 points here i want rank 1

with rankx i get rank with each row