Forum Discussion
Harineeeeeeee
Helper I
Helper IHow 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...
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]))) + 1I 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.
Daniel29195
Community Champion
Community ChampionHello Harineeeeeeee ,
are you able to show the example and the output that you would want to achieve ? that would help alot
best regards,
HarineeeeeeeeHelper I
Helper IConsidering yellow table is from table A and orange is from table b , after i create a visual combining table a and table b , i want to create a index number
Can you please suggest any ways?