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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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

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