row number

[PavaniD]

Hello

I need row number for my table.I want it as a measure as my data model is Azure Analysis Services,I cant edit my data model.So I want a measure in report itself.

[v-kongfanf-msft · Accepted solution]

Hi @PavaniD ,

As @Ritaf1983 said, you can implement the creation of line numbers by MEASURE through the rankx function.

The usual practice can be combined with the allselected function, which can be dynamically adjusted according to the slicer.

result_ = SUM('Table'[Value])

Index = RANKX(ALLSELECTED('Table'[Cate]),[result_])

Best Regards,
Adamk Kong

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

[PavaniD]

No,I dont have access to use edit query mode.So I want that as a measure only.

[Ritaf1983]

@PavaniD 
Then it sounds like you should use rankx function.
Take a look at the linked video :

https://www.youtube.com/watch?v=gXF47dSmIwI

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

[Ritaf1983]

Hi @PavaniD 
You can add an index column with PQ:

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