Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Add row number to Filtered table

Hello, I need to add to my table view a row_number column which needs to reset based on the selection. For example, if I select the territory Canada, I need to have row_numbe from 1 to 100 let's say...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello Greg_Deckler , I am trying to achieve what is described here, I am using the exact same functions but my row number column has the value 1 for all rows.

 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Anonymous - I don't have an example of what your data looks like, but I mocked something up. See what you think. PBIX is attached below sig, Table 12, Measure 12, Page 12.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello Greg_Deckler , thank you for your example.  I have checked my data set and it includes a Date column, which is the lowest level of detail for the data. In my report I do not display this column because I make LTD calculations. If I add this column in the data table the row number is calculated correctly: 

     

    but if I remove that column then the numbers will be displayed incorrectly.

     

     

    Is there any way of calculating the correct index only for the data displayed? Thank you.