Forum Discussion
Dynamic Ranking within a category
Hi All, I am trying to build a visual which shows dynamic rank for Patients falling in each category, and that ranking should get updated as per the Date filtered. This is the original rank based on...
Anonymous , if you are creating a column Rank.
Rank = rankx(filter(Table, [Category] = earlier([Category]) , [Date],,asc,dense)
But I think you need a measure
Countx(filter(allselected(Table) , [Category] = Max([Category]) && [Date] <= Max([Date]) ), [Date])
Just to Clarify, i need help with creating this Rank measure/ Column. I have either been able to create rank by Category that doesnt update as per date filter OR create dynamic rank that doesn't rank by category.