Row Number RANKX

[LUCASM]

Hi I am attempting to add a row number to my Table visual

I have a table of Products, Sales Volume & Sales Value and by default it is sorted decending by Sales Volume

I have attempted 

Row Number = RANKX(
    ALL('My Table'[Product]),SUM('My Table'[Sales Volume]),,DESC,DENSE)

but it retuns 1 for every row

[amitchandak · Accepted solution]

@LUCASM , First use calculate, if you are not using measure, second add other columns in visual

Row Number = RANKX(
ALL('My Table'[Product]),calculate(SUM('My Table'[Sales Volume])),,DESC,DENSE)

Power BI Rank Across dimension tables: https://youtu.be/X59qp5gfQoA