Forum Discussion

Harineeeeeeee's avatar
Harineeeeeeee
Icon for Helper I rankHelper 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
Icon for Skilled Sharer rankSkilled Sharer
2 years ago

Harineeeeeeee your approach is right.

You can modify the query using the following formulas  

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

 

or

Index = COUNTROWS(FILTER(ALLSELECTED(MainTable), MainTable[id] <= EARLIER(MainTable[id])))

 

Let me know if this works for you. @ me in replies, or I'll lose your thread!!!  
Note: 

If this post helps, 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.