How to count how many row of my Table ?

[admin11]

Hi All

My existing table :-

I hope to achieve like below :-

[Anonymous · Accepted solution]

Hi @admin11 ,

You can add a index column from Power Query and use it in your visual

[v-xiaoyan-msft]

Hi @admin11 ,

Does the replies above solve your problem? If it has been solved, please mark the correct reply as the standard answer to help the other members find it more quickly.Thanks in advance for your kind cooperation!

Hope it helps,

Community Support Team _ Caitlyn

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

[Anonymous · Accepted solution]

Hi @admin11 ,

You can add a index column from Power Query and use it in your visual

[smpa01]

@admin11  you need to provide a sample, else hard to tell

[admin11]

@smpa01 

Thank you for your help.

https://www.dropbox.com/s/lep6phoh6hyr9ov/How%20to%20count%20number%20of%20row.pbix?dl=0

Above link is my sample file.

Paul

[smpa01 · Accepted solution]

@admin11  you can create a rowNum with RANKX. Please understand that there is no concept of RoW Number like you create one in excel. But you can create a dynamic Ranking which will be same as Row Num based on the measure like following.

_rowNum = RANKX(ALLSELECTED(SALES[BRAND_C]),[Sales Vari %],,DESC)