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

spuder's avatar
spuder
Resolver IV
8 years ago

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. :smileysad: