Forum Discussion

saud968's avatar
saud968
Memorable Member
2 years ago
Solved

Ranking for multiple entries

Hi, 

I have multiple entries as you can see below screenshot the number should have MonthUnique Count as 1, 2 but it is showing up as 1

 

 

https://drive.google.com/file/d/1Y_qQCdj5pxf2Pvn8zMIzJxeMw4lMYGGk/view?usp=drivesdk


@lbendlin @Ahmedx 

 @Ritaf1983 

Data Protection
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • saud968's avatar
    saud968
    2 years ago

    Ahmedx I was able to get the work done by 

    MonthUniqueCount =

    RANKX(
        FILTER(
            WeekUniqueTicketTable,
              WeekUniqueTicketTable[Month Unique Ticket] = EARLIER(WeekUniqueTicketTable[Month Unique Ticket])
           
        ),
        WeekUniqueTicketTable[EDITED_DATE],
        ,
        ASC

4 Replies

  • Ahmedx's avatar
    Ahmedx
    Super User
    2 years ago

    can you explain the logic - why 1,2,3 on the basis of what it should be like one example

    • saud968's avatar
      saud968
      Memorable Member
      2 years ago

      Just wanted to add this as a screenshot because for some weird reason, the reply is not saving. 

       

      • saud968's avatar
        saud968
        Memorable Member
        2 years ago

        Ahmedx I was able to get the work done by 

        MonthUniqueCount =

        RANKX(
            FILTER(
                WeekUniqueTicketTable,
                  WeekUniqueTicketTable[Month Unique Ticket] = EARLIER(WeekUniqueTicketTable[Month Unique Ticket])
               
            ),
            WeekUniqueTicketTable[EDITED_DATE],
            ,
            ASC