Forum Discussion

Harineeeeeeee's avatar
Harineeeeeeee
Helper I
2 years ago
Solved

How to create index on visual table

Hey everyone I have created a table visual with multiple colums from different table after creating the visual I would like to create a index column in the table visual how to do this ? Any leads he...
Need Help
  • DallasBaba's avatar
    DallasBaba
    2 years ago

    Harineeeeeeee The index column is not displaying unique values because of the  ALLSELECTED function.

    You can try using ALL('MainTable') instead of ALLSELECTED('MainTable')

    IndexColumn = RANKX(ALL('MainTable'), 'MainTable'[id], , ASC, Dense)

    Or 

    Index = COUNTROWS(FILTER(ALL(MainTable), MainTable[id] < EARLIER(MainTable[id]))) + 1

     

    I hope this meets your needs. If so, please consider Accepting it as the solution to help others find it more quickly. OR
    If my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

     
    Best Regards,
    Dallas.

     

     

DallasBaba's avatar
DallasBaba
Skilled Sharer
2 years ago

Harineeeeeeee The index column is not displaying unique values because of the  ALLSELECTED function.

You can try using ALL('MainTable') instead of ALLSELECTED('MainTable')

IndexColumn = RANKX(ALL('MainTable'), 'MainTable'[id], , ASC, Dense)

Or 

Index = COUNTROWS(FILTER(ALL(MainTable), MainTable[id] < EARLIER(MainTable[id]))) + 1

 

I hope this meets your needs. If so, please consider Accepting it as the solution to help others find it more quickly. OR
If my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

 
Best Regards,
Dallas.