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.

     

Anonymous's avatar
Anonymous
Not applicable
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.