Unique Serial Numbers even when we have duplicate records

If you try doing it with a dax measure then you get inconistent results depending on the filters.

Consider doing it in Power Query, so your reports will show a consistent serial number for the rows.

For example ...

Create some test data

Group By Vendor using the Operator = All Rows

Add a custom column

Table.AddIndexColumn([Count],"Index",1)

Expand the Serial Number column

Remove unneeded columns

Congratualations, you now have a serial number for each row that restarts from 1 for each Vendor

Please click thumbs up because I have tried to help.

Then click [accept solution] if it works.

Thank you !