Concatenate rows / ID Creation / Calculated Column

[Oceans88]

Hello All,

Im trying to create an ID for "Cycle.Name" from the "Rank" column. As you can see below, there is some concatenation going on but its not in the correct order and same ID is getting repeated over and over again regardles of "Cycle.Name". i would like if possible to have ID in same row order of rank top to bottom as well as a unique ID per "Cycle.Name"

Please vew below, I will also include my current DAX for "CycleID.AGGR"

Thank you for any possible help.

CycleID.AGGR = 
CONCATENATEX(FILTER(SUMMARIZE('55.Table.Cycle.Aggregation','55.Table.Cycle.Aggregation'[Cycle.Name],'55.Table.Cycle.Aggregation'[Rank]),'55.Table.Cycle.Aggregation'[Cycle.Name]=EARLIER('55.Table.Cycle.Aggregation'[Cycle.Name])),'55.Table.Cycle.Aggregation'[Rank],BLANK())

[v-jayw-msft · Accepted solution]

Hi @Oceans88 ,

Please correct me if I misunderstand your meaning.

Create a index column for the table and create a support column.

support_column = CALCULATE(MIN('Table'[Index]),ALLEXCEPT('Table','Table'[Column1]))

Then create the new index column.

new_index = RANKX('Table','Table'[support_column],,ASC,Dense)

Best Regards,

Jay

[Oceans88]

Shameless bump lol. Anyone have any ideas on this issue? 

Kr