cancel
Showing results for
Did you mean:
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 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

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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.

Super User

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

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.

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

Announcements

#### Launching new user group features

Learn how to create your own user groups today!