I have a rank measure defined as
Hi @jspo ,
I created some data:
Here are the steps you can follow：
1. Enter power query through transform data and select add column --- index column --- from 1 to generate the index
2. Create measure.
amount_measure = MAX('Table'[amount])
Rank = RANKX(ALLSELECTED('Table'),CALCULATE([amount_measure]+MAX([Index])*0.001),,ASC,Dense)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This did not solve our issue. This is basically a 2 tier ordering. really we need to fix the numbering to be correct so we can retain confidence in our dashboard.
@jspo , Try with dense
m_Dealer Rank DESC =
RANKX(ALL('Register'[Name]),[m_Gross Margin %],,DESC,dense )
Refer to break ties
Check out the News & Announcements to learn more.
Microsoft received the highest score of any vendor in both the strategy and current offering categories.
Mark your calendars and join us for our next Power BI Dev Camp!
Check out our new Discover Your Career Path blog post series and get all the details.