Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
1 year ago
Solved

INDEX column in Table visual

Good day everyone

I'd like to know if there's a way to configure a Table-type visual to contain the row index in the first column.

That is, regardless of the filters and the ordering that the end user makes on the table, the first row will say the number 1, the second the number 2 and so on...

I was looking at other solutions and it does not help me to establish a ranking to use the ranking result as an index, specifically this serves me so that when the user performs the export of the table after performing the filters that he deems necessary, this export reports the column number.

Thank you all very much

Best regards

Pablo

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Syndicate_Admin 

     

    Based on your needs, I have created the following table.



    Then you can use the following measure to get the result you want:

     

    _value = SUM('Table'[value])

     

    Row Index = 
IF(
ISINSCOPE('Table'[value]),
RANKX(ALLSELECTED('Table'), [_value], , ASC, DENSE)
)

     

    Result:




     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Syndicate_Admin 

     

    Based on your needs, I have created the following table.



    Then you can use the following measure to get the result you want:

     

    _value = SUM('Table'[value])

     

    Row Index = 
IF(
ISINSCOPE('Table'[value]),
RANKX(ALLSELECTED('Table'), [_value], , ASC, DENSE)
)

     

    Result:




     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.