Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Trying to create a dynamic row number in a table visual

I need to add a Row number to one of my table visuals. I've created a unique index column in the underlying table. The index can be used to create a row number starting from Row 1. Unfortunately when...
  • sevenhills's avatar
    1 year ago

    Two points if known, can provide accurate syntax.

     

    Use case: you are trying to get the row number based on filter selection of each row. 

     

    Assuming you have index column to identify unique row, then you can use this.

     

    Try this:

    Row_Number = 
    CALCULATE (
        COUNTROWS('Table');
        FILTER ( ALLSELECTED ('Table'), 'Table'[Index] <= MAX ( 'Table'[Index]) )
    )
     

     

    Or  If not you can use all the filters that are applied to the table.

     

    Row_Number = 
    var _v1 = SELECTEDVALUE ( 'Table'[filterColumn1])
    var _v2 = SELECTEDVALUE ( 'Table'[filterColumn2])
    RETURN CALCULATE ( COUNTROWS('Table');
        FILTER ( ALLSELECTED ('Table'),
               'Table'[filterColumn1] <= _v1 && 'Table'[filterColumn2] = _v2 )
    )

     

    Hope this helps!