Forum Discussion
Let-Me-Know
3 years agoFrequent Visitor
Getting dynamic serial numbers for rows in Matrix Visual
Dear all, My goal is to implement dynamic serial numbers for rows in a Matrix Visual. My input data is „Data Table“ with these columns: Name Parent Employee Influencer John ...
amitchandak
3 years agoSuper User
Let-Me-Know , Try the new rownumber function released in April 2023
example
New Row Number = ROWNUMBER(ALLSELECTED(Table[Name]),ORDERBY(Table[Name],asc))
Let-Me-Know
3 years agoFrequent Visitor
Hi, amitchandak
Thnx for the hint.
You gave an example:
New Row Number = ROWNUMBER(ALLSELECTED(Table[Name]),ORDERBY(Table[Name],asc))
But how would it look like if you had implemented my table and column titles? Would it look like this?
ROWNUMBER = ROWNUMBER(ALLSELECTED(Data Table),ORDERBY(Data Table[Parent and/or Influence],asc))
I have tried that but it does not work. After I add that measure as a column in my table, I get the message