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.
Hello All,
How can we create a index calculated column or measure using DAX, like we do in power query.
Any help.
Mohan V
Solved! Go to Solution.
Hi @Anonymous,
What does your data source look like? I create the following sample table and get expected result.
I create measure using the formula below.
Index = RANKX(ALL(Test),FIRSTNONBLANK(Test[Project ID],Test[Project ID]),,ASC,Dense)
Then create a table, select the Project ID and measure as the value level, you will get expected result as follows.
Best Regards,
Angelia
Hi @Anonymous,
have you tried to use the RANKX() function. This calculates a ranking depending on a value. So you should be able to generate an index column with it.
Greetings
spuder
@Anonymouswhat is the sort order of your table and does it has duplicate values in the sorted columns?
@Anonymous
then it should be working with RANKX()
@spuder I just tried this.
But i got the output which i am not expecting.
I would like to get the no of rows that i will be having in that table dynamically,
like in that above image i should get as 1
2
3
4
5
Values.
Any help
Hi @Anonymous,
What does your data source look like? I create the following sample table and get expected result.
I create measure using the formula below.
Index = RANKX(ALL(Test),FIRSTNONBLANK(Test[Project ID],Test[Project ID]),,ASC,Dense)
Then create a table, select the Project ID and measure as the value level, you will get expected result as follows.
Best Regards,
Angelia
You can't rely on RANKX when adding Index as RANKX generates same index for the similar target column values.
OK. But as far as I can see. You don't want to index a source table but a table visual, right? And the table visual does not include all Project IDs, right? Then it won't work that way. Because you always rank against the source table with ALL Project IDs.
So I don't see a solution to get this problem working. Sorry.
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |