Reply
saud968
Super User
Super User
Partially syndicated - Outbound

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

 

saud968_1-1701407501304.png

 

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


@lbendlin @Ahmedx 

 @Ritaf1983 

1 ACCEPTED SOLUTION

Syndicated - Outbound

@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

View solution in original post

4 REPLIES 4
Ahmedx
Super User
Super User

Syndicated - Outbound

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

Syndicated - Outbound

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

saud968_0-1701422586636.png

 

Syndicated - Outbound

@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

Syndicated - Outbound

@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. 

avatar user

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)