Forum Discussion
Dynamic Measure based on slicer selection
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.
Hi Aria89
Create a measure that ranks by the order your comments are in.
I assume its alphabetical so something like this:
Thanks for the response. I created that measure but when i add it in the visual, all the values are disappeared... Any ideas what can be wrong?
What else is in the table visual?
Are you applying any filters to the visual?
The row would dissapear if the measure is returning blank.Tha table visual only has the Comments column and the new measure that I created. Note that that table has another column as well with Dates but I am not filtering based on the dates.
