Dynamic row number_rank for part of a column

[User2023_2023]

Hello, i am a new Power BI user.

Have RANK for GROUP # 2, but for GROUP #1 need to get dynamic ranking / row number, which will be contnuos strarting from 1 even if a filter was applied (e.g. USER).

Would gretaly appreciate your help!

[amitchandak]

@User2023_2023 , I am not seeing any measure in visual, do you need the row number for use?

if yes then use a measure count and rownumber released in April 2023

Rankx is old function rank and rownumber are new one

count = countrows(Table)

New Row Number = ROWNUMBER( ALLSELECTED(Table[User]),ORDERBY([Net],DESC),PARTITIONBY (Table[Group]))

Rank Old Dense = rankx(ALLSELECTED('Table'[User]), [Your Measure],,DESC,Dense)

New Rank Desne = rank(DENSE,ALLSELECTED(Sales[Order No]),ORDERBY([Net],DESC),PARTITIONBY(Table[Group]))

Column rank cannot be dynamic , in case you are creating one