Forum Discussion
How to create Automatically generate serial number
Hello, The table below shows my data structure. I want to create a measure to automatically generate a serial number starting from 1, even if I use filters. My problem is that the values are not...
hello Mariano92
You can try using RANKX dax as below:
Calculated Column = RANKX('TableName',TableName'[Serial No],,ASC,Dense)
or you can also add index column which starts from 1 directly as below :