Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
saud968
Impactful Individual
Impactful Individual

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
saud968
Impactful Individual
Impactful Individual

@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

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

saud968
Impactful Individual
Impactful Individual

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

saud968_0-1701422586636.png

 

saud968
Impactful Individual
Impactful Individual

@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
Impactful Individual
Impactful Individual

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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