Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Running count not based on a table column

Hi,   I would like to place a running count column on a table visual, that has a value starting from 1 on the first row and incrementing by 1 for each following row.  I know I can do this based on a...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi Anonymous ,

     

    I don't think what you're trying to achieve is possible.  For a sequence to work, it must reference a column and changing the order of rows in such a column would result to your sequence changing as well.

Fowmy's avatar
Fowmy
Super User
2 years ago

Anonymous 

UIse this measure:

RC = 

COUNTROWS(
    WINDOW(
        0,ABS,
        0,REL,
        SUMMARIZE( ALLSELECTED( 'SLR' ) , 'SLR'[LasName] ),
        ORDERBY( 'SLR'[LasName] , ASC )
    )
)
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Fowmy,  it works only if the LastName column is sorted in ascending order.  If I sort on the same column, but with descending order, then the first row's running count does not start from 1 but instead is the value that is the maximum row count.  And if I sort on a different column, then the row count is not in sequential order, either ascending or descending.

Thanks, Mike.