Forum Discussion

Aria89's avatar
Aria89
Helper I
1 year ago
Solved

Dynamic Measure based on slicer selection

Hi everyone,    I have a table which has a column, let's say called "Comments". I have created a slicer that lists all the comments and the user can select only the comments that they want. Based o...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Aria89 ,

     

    Based on your description, I created this data.

     


    Create the measure as SamWiseOwl  said.

    Measure =
RANK(SKIP,ALLSELECTED('Table'),ORDERBY('Table'[Comment]))


    Successfully returned the expected result, you can refer to the attachment I provided to compare with your file. If possible, you can also provide your data (with sensitive data removed) so that we can better help you solve the problem.

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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

     

Aria89's avatar
Aria89
Helper I
1 year ago

Thanks for your response. 

 

The thing is that if I just add an index column, the number associated with each comment is not going to change dynamically. I want the numbers shown in my table visual to always be 1,2,3,4 etc no matter what comments have been selected in the slicer. 

bhanu_gautam's avatar
bhanu_gautam
Super User
1 year ago

Ok got it than you can use RANK function as stated by SamWiseOwl  to create a measure and use it