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])
Hi, Thanks for helping. I tried creating calculated column(similar to Rank by Test Type in mentioned post) but i see only 1 getting populated for each row.
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])