Forum Discussion
dk_24
Helper I
Helper IIndex 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)
dk_24Helper I
Helper IPlease fnd the below picture ,
please let me know if your not clear with this.
Thanks,
Eric_Zhang
Microsoft Employee
Microsoft Employee
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)
- dk_24Thanks 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."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)
- dk_24
sorry i have cretead meaasure.now its working as expected. thanks.