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 Happy to know it works.  Kindly @ me with any future needs around Power BI and Fabric.

Please give it a kudos by clicking the Thumbs Up! It goes a long way to helping others find this solution quickly.

 
Best Regards,
Dallas.