Show Row dynamic number in a table

[Anonymous]

Hi all.

I have a doubt, I would like to show in a table a secuencial number like this:

In this case, it cannot be repeated, they always have to go up from 1 to X.
Any suggestion?

[v-lionel-msft]

Hi @Anonymous ,

Step1, Add an index column in Power Query.

Step2, Create a measure.

Measure = 
RANKX(
    ALLSELECTED('Table'),
    CALCULATE( MAX([Index]) ),
    , ASC, Dense
)

Then you can get the dynamic number of the row.

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 · Accepted solution]

@Anonymous , you might have to create rank and display

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

Or in your table, you can add an index column (This will be for the table)

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

[Anonymous]

Hi, thanks for your answer, finally I used this method that you indicated => https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures