Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@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_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.
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.
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)
sorry i have cretead meaasure.now its working as expected. thanks.
@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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |