power Bi direct query giving incorrect row number some times

[Anonymous]

Hi,

my source is sql server using directy query in  PBI.I have created row number measure, i will use this row number for running total calculation.very few times this row number is calculating incorrect(example row number starting from 17 instead of 1).

my source sql server contionously updated every minute with C sharp application.

In below screen shot seq num(row number) is correctly generated.

In below screen shot seq num(row number) is Incorrectly generated.Please help

measure formula:

DistanceIntM =

VAR MaxValue = MAXX(ALL('BlockSubBlock'),'BlockSubBlock'[ID])

VAR SlicerValue = SELECTEDVALUE('BlockSubBlock'[ID],30)

RETURN

    IF(min('vwMWSystemWideEEP'[ID]) >= SlicerValue,

       min('vwMWSystemWideEEP'[ID]) - SlicerValue,

       min('vwMWSystemWideEEP'[ID])  +(MaxValue- SlicerValue)

    )

;

 below is row number measure

UniquekeyIntM = ROWNUMBER(ALL(vwMWSystemWideEEP),ORDERBY([DistanceIntM],ASC,vwMWSystemWideEEP[RowNo],ASC))