Hi

I have a table visual with three columns of data in Power BI, and I would like to add an index column that starts from 1 and increments by 1 up to the number of rows in the Name column. Specifically, when the data in the table is filtered, the index column should update to reflect the number of rows in the filtered result.

Name- calculated column from app table and contains duplicates

Age- measure

City- measure

Index- start the sequence from 1 and ends at the no of rows of the name column in the table visual. Duplicates should not effect the sequence.

Sample Data (Before Filtering):

Sample Data (After Filtering for "Age > =25"):we use slicer for the filter purpose

As you can see, the index should reset based on the filtered data, providing a new row number for each filtered result.

Could someone suggest the best way to implement this dynamic index in my Power BI report? Thank you!