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

DallasBaba 

 

Thanks for the below, now the values are not unique but it gives me some random number not realy sure on what basis that random number is coming, even though i used maintabl[id] as index column which starts from 0.

 

Any thoughts on this?

 

Thanks

  • DallasBaba's avatar
    DallasBaba
    Icon for Skilled Sharer rankSkilled 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.