serial number dynamic generation with alphabetical order column of text type.

[nagasaikumarb22]

 This is sorted in table visual and a slicer is present to distinguish tropical and non tropical fruits.

Now we require a serial number as per alphabetical order.

Requiremnt as above.

Please kindly suggest any DAX

[nagasaikumarb22]

Thank you for the time,now the complextity had been reduced but not yet done because i have repetetive fruit names in same year due to months variation which should not be taken into consideration.price column should be grouped sum not individual.

[nagasaikumarb22]

[v-xinruzhu-msft · Accepted solution]

Hi @nagasaikumarb22 

You can make the name column sort by ascending first, then add an index column to the table in power query.

Then create the measure 

s.no = RANKX(ALLSELECTED('Table'),CALCULATE(SUM('Table'[Index])),,ASC,Skip)

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[nagasaikumarb22]

Hi thanks for your time,

But it didnt fulfill my requirement yet due to following conditions i mentioned in post,

1.Slicer selection is deviating my serial number.(Lets say year slicer  is also included. )

2.Data is not sorted in ascending prior.

[v-xinruzhu-msft]

Hi @nagasaikumarb22 

I don't quite understand what you mean, is the data you are referring to letters. The data I provided is not sorted in ascending order by value.

What I've provided is an incremental dynamic sort in alphabetical order, and it is only affected by the alphabetical column

can you provide some examples of the results you expect?

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xinruzhu-msft]

Hi @nagasaikumarb22 

You can create a measure.

e.g 

s.no = COUNTROWS(FILTER(ALLSELECTED('Table'),[Fruit name in Asc order]<=SELECTEDVALUE('Table'[Fruit name in Asc order])))

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.