Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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.
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Kong

     

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

  • Ritaf1983's avatar
    Ritaf1983
    Super User
    2 years ago

    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