add incremental Column

[Anonymous]

Hi All,I need small help.

How to provide Incremental Ranking, Incremental number or Add dynamic column to show on serial wise like Top 50 Rakings.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Try to create two measures:

Max = MAX('Table (2)'[Value])

Rank = 
RANKX(
   ALLSELECTED( 'Table (2)'),
    [Max],
   , DESC, Dense
)

Result picture 

Best regards,
Lionel Chen

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

[amitchandak]

You can index column

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

For Rank Refer these links
https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures
https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns
https://radacad.com/how-to-use-rankx-in-dax-part-3-of-3-the-finale