cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
EricWu
Frequent Visitor

Dynamic rank with Group

Hi,

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

Project Project NumberDateRank
A1011/1/20214
A1012/1/20213
A1013/1/20212
A1014/1/20211
B1023/1/20213
B1024/1/20212
B1028/1/20211

 

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

Project Project NumberDateRank
A1011/1/20213
A1013/1/20212
A1014/1/20211
B1023/1/20212
B1024/1/20211

 

Thanks 

1 ACCEPTED SOLUTION
v-polly-msft
Community Support
Community Support

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.

11.png

22.png

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.

View solution in original post

2 REPLIES 2
v-polly-msft
Community Support
Community Support

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.

11.png

22.png

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.

View solution in original post

parry2k
Super User
Super User

@EricWu 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.






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.