Index for text table

[dk_24]

Hi All,

i have to give the serail number to the text table like 1,2,3.for that i have created one index column.i have total 30 rows in source,so it's given 1 to 30 numbers.but when i summarige(Average the 30 records user wise) it giveing 27,28,30 instead of 1,2,3.

how t get the index for the below text table.

[Eric_Zhang]

---

@dk_24 wrote:

Hi All,

i have to give the serail number to the text table like 1,2,3.for that i have created one index column.i have total 30 rows in source,so it's given 1 to 30 numbers.but when i summarige(Average the 30 records user wise) it giveing 27,28,30 instead of 1,2,3.

how t get the index for the below text table.

---

@dk_24

Your description is not clear for me, would you mind sharing the pbix file? You can upload it to Onedrive/GoogleDrive and share the download link. Do remember to mask sensitive data before uploading.

[dk_24]

Please fnd the below picture , 

please let me know if your not clear with this.

Thanks,

[Eric_Zhang · Accepted solution]

---

@dk_24 wrote:

Please fnd the below picture , 

please let me know if your not clear with this.

Thanks,

---

@dk_24

So what you need is the index column? I'm not clear about what did you do while getting 27,28,29 as described, however you can create a calculated column with DAX.

index = RANKX(yourTable,yourTable[UserName],,ASC,Dense)

[dk_24]

sorry i have cretead meaasure.now its working as expected. thanks.

[dk_24]

Thanks for your response. no luck , getting the below error. "A single value for column 'User Name' in table 'Table1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

[Eric_Zhang]

---

@dk_24 wrote:
Thanks for your response. no luck , getting the below error. "A single value for column 'User Name' in table 'Table1' cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result."

---

@dk_24

I mean creating a calculated column, not a measure.

If a measure is required, you could try

index = RANKX(ALLSELECTED(yourTable),CALCULATE(MAX(yourTable[username])),,ASC,Dense)