Forum Discussion
row number
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.
Hi Anonymous ,
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Anonymous
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
Anonymous
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
Hi Anonymous ,
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 KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
