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
Or, what would be a solution with COUNT and OR functions, aka Excel way to count:
COUNT how many people are a parent OR an influencer?
In my example, there are three of them.
I would then put that number in another table visual.