cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## Add a Calculated index column using DAX

Hello All,

How can we create a index calculated column or measure using DAX, like we do in power query.

Any help.

Mohan V

1 ACCEPTED SOLUTION
Employee

Hi @Anonymous,

What does your data source look like? I create the following sample table and get expected result.

sample table
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

9 REPLIES 9
Resolver IV

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

Anonymous
Not applicable

I tried @spuder... but could find the solution.

Any hint that how can i achieve it.

Resolver IV

@Anonymouswhat is the sort order of your table and does it has duplicate values in the sorted columns?

Anonymous
Not applicable

@spuder it is ascending and no it dont have any duplicate values.

Resolver IV

@Anonymous

then it should be working with RANKX()

Anonymous
Not applicable

@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

Employee

Hi @Anonymous,

What does your data source look like? I create the following sample table and get expected result.

sample table
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

Post Prodigy

You can't rely on RANKX when adding Index as RANKX generates same index for the similar target column values.

Resolver IV

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.

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

#### Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors