Column with line number in PBI table

[Jo_Chrq]

Hello,

I did a report with a table that ranks several brands my company sells, based on each brand income.

I would like to add a first column with the line numbers (ranking).

Is there a way to do so?

Thanks in advance

Jo

[amitchandak]

@Jo_Chrq , are you looking for serial no of line ?

Not there. You have to use Rank if possible. Vote for the idea -https://ideas.powerbi.com/ideas/idea/?ideaid=80612ec5-14a9-4929-a2ee-531943fa51d4

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
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[Jo_Chrq]

Hi @amitchandak 

Yes  believe that's it.

If you consider the following table, I have the columns "Stores" and "Revenue" and basically I need to add the Rank column :

Rank (column needed)	Stores	Revenue
1	Store B	100€
2	Store C	95€
3	Store A	75€

[harshnathani]

Hi @Jo_Chrq ,

Create these 2 measures

Total Sales = SUM('Table'[Revenue])

RANK = RANKX(ALL('Table'[Stores]), [Total Sales],,DESC)

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Jo_Chrq]

Hi @harshnathani 

Thank you, I'm now getting really close but still have an issue.

The table actually has an extra column and the ranking I get is within these categories (btw I apologize for my poor English level ...)

Here's the result I get :

Rank	Regions	Stores	Revenue
1	North	Store B	100€
2	North	Store C	95€
1	South	Store A	75€
3	North	Store F	60€
2	South	Store D	55€

I would like to have the overall ranking, regardless the regions ...

Many thanks again

[harshnathani]

Hi @Jo_Chrq ,

RANK = RANKX(ALL('Table'),CALCULATE(SUM('Table'[Revenue  ])))

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[harshnathani · Accepted solution]

Hi @Jo_Chrq ,

You can also try

RANK = RANKX(ALL('Table'[Regions   ],'Table'[Stores     ]),CALCULATE(SUM('Table'[Revenue  ])))

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Jo_Chrq]

Hi @harshnathani 

Yes it works perfectly! thanks

Jonathan

[Pragati11]

Hi @Jo_Chrq ,

Please share additonal details on your query. This is not helping at all.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati