Running number in table

[Busno]

Hi, Everyone,

 I need some help. I made a table show the Largest to the smallest number of sales and I need a running number I in the first column.

Like this

 

How can I get the number in Column A

Ps. Model from Table A

      The unit from Table B

Thank you

[v-gizhi-msft · Accepted solution]

Hi,

Please try this column in table B:

No. = RANKX('Table B','Table B'[Unit],,DESC,Dense)

The result shows:

See my attached pbix file.

Best Regards,

Giotto

[amitchandak]

@Busno , not very clear you need running total or sort. For sort you can do it on that column

for running total you can use Quick measure and create one

[Busno]

Sorry, I just need a row number. This table is the top 10 model.

[parry2k]

@Busno first create a rank column based on the highest number and then do the cumulative total on it

https://radacad.com/how-to-use-rankx-in-dax-part-1-of-3-calculated-columns

https://community.powerbi.com/t5/Desktop/Cumulative-SUM-using-Rank-NOT-Dates/td-p/170623

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!