Ranking for multiple entries

[saud968]

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 

@Idrissshatila @amitchandak @parry2k @technolog 

 @Ritaf1983 

[Ahmedx]

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

[saud968]

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

[saud968 · Accepted solution]

@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

[saud968]

@Ahmedx can I accept my own solution as a solution? Is it possible and not violate any rules. If not could you please accept it as solution for me.