Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    3 years ago

    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])

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.

    • amitchandak's avatar
      amitchandak
      Super User
      3 years ago

      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])