Rownumber sometimes skips a number

[ldwf]

I have a simple table visual that users drill thru to, and added a row number column to label each row in the table.  I created an index column and am using this in my DAX fomula.  

Row Number=

CALCULATE(

    COUNTROWS('Table'),

    FILTER(ALLSELECTED('Table'), 'Table'[Index] <= MAX('Table'[Index]))

)

The results in the table shows the correct number of rows, but the row number column is sometimes being incremented by a number more than 1:

I use this DAX formu; a lot with no issues, but for some reson it skips.  Any thoughts?

[ryan_mayu]

@ldwf 

maybe you can try 

Row Number=

CALCULATE(

    COUNTROWS('Table'),

    FILTER(ALLSELECTED('Table'), 'Table'[Index] <= MAX('Table'[Index]))

)+0

or show items with no data

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data?wt.mc_id=DP-MVP...

[ldwf]

Unfortunately, that did not help.  It made the value zero for every record in the table

[ryan_mayu]

could you pls provide some sample data?