Forum Discussion
Solved
Index for text table
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(Av...
dk_24 wrote:
Please fnd the below picture ,
please let me know if your not clear with this.
Thanks,
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)
Please fnd the below picture ,
please let me know if your not clear with this.
Thanks,
dk_24 wrote:
Please fnd the below picture ,
please let me know if your not clear with this.
Thanks,
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)
- 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 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."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)
sorry i have cretead meaasure.now its working as expected. thanks.