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
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

Anonymous - Sample data would help, but maybe the Mythical DAX Index? https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Mythical-DAX-Index/m-p/1093214#M528

 

Or maybe something dealing with RANKX? https://community.powerbi.com/t5/Quick-Measures-Gallery/To-Bleep-with-RANKX/m-p/1042520#M452

 

Or maybe Cthulhu? https://community.powerbi.com/t5/Quick-Measures-Gallery/Cthulhu/m-p/509739#M211

 

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

  • 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.