Forum Discussion

Let-Me-Know's avatar
Let-Me-Know
Frequent Visitor
3 years ago

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 ...
Need Help
  • Let-Me-Know's avatar
    Let-Me-Know
    Frequent Visitor
    3 years ago

    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

     

     

  • Let-Me-Know's avatar
    Let-Me-Know
    Frequent Visitor
    3 years ago

    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.