Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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  
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

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

  • gvg's avatar
    gvg
    Post Prodigy
    7 years ago

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