Dynamic rank with Group

[Anonymous]

Hi,

I am tring to create a measure which can dynmaic rank data by date and partition by project name 

Project	Project Number	Date	Rank
A	101	1/1/2021	4
A	101	2/1/2021	3
A	101	3/1/2021	2
A	101	4/1/2021	1
B	102	3/1/2021	3
B	102	4/1/2021	2
B	102	8/1/2021	1

If I select Jan,Mar,Apr in slicer. data will show this way 

Project	Project Number	Date	Rank
A	101	1/1/2021	3
A	101	3/1/2021	2
A	101	4/1/2021	1
B	102	3/1/2021	2
B	102	4/1/2021	1

Thanks 

[v-rongtiep-msft · Accepted solution]

Hi @username,

Create two measures.

date__ = SELECTEDVALUE('Table'[Date])

rank_m = RANKX(FILTER(ALLSELECTED('Table'),'Table'[Project ]=SELECTEDVALUE('Table'[Project ])),[date__])

Put date into slicer.

Best Regards

Community Support Team _ polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@Anonymous check this post, it has everything you need.

✨ Follow us on LinkedIn

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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.⚡