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, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Kumar11109
Helper IV
Helper IV

Day Ranking For Group Access

Hi All,

 

I am trying to rank the usage day for a set of groups. I have used the below formula but the ranking formula is not working. 

 

DayRank_ =
RANKX (
FILTER (
ALL ( VIEW_SCOREINFO_ALL ),
VIEW_SCOREINFO_ALL[GroupId] = EARLIER ( VIEW_SCOREINFO_ALL[GroupId] )
&& VIEW_SCOREINFO_ALL[Session Date] = EARLIER ( VIEW_SCOREINFO_ALL[Session Date])
),
VIEW_SCOREINFO_ALL[Index],
,
ASC,
DENSE
)

 

 

 

 

The result is as follows: 

 

Untitled.png

 

Can someone help me with the  formula. 

 Sample Data

The way I want is also given here. 

 

Thank You, 

Kumar Ashwarya 

1 ACCEPTED SOLUTION

@Kumar11109

Please check this modified PBIX file.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

8 REPLIES 8
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@Kumar11109,

Create the rank column using DAX below.

RANK = RANKX(FILTER(VIEW_SCOREINFO_ALL,VIEW_SCOREINFO_ALL[GroupId]=EARLIER(VIEW_SCOREINFO_ALL[GroupId])),VIEW_SCOREINFO_ALL[Session Date],,ASC)

1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

This formula is not working. I am getting the below result. 

Its not working. :-C

 

 

ResultResult

 

 

 

I think I should have more clear, my data set looks something like this. 

 

Sample Data

 

Thats why I think its not working. I also used to Dense so that it doesn't skip ranking for a group, but that didn't work either. 

 

 

Screenshot (13).png

@Kumar11109

You have different sample data as before. What field do you want to rank this time? And what is  your expected result?

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

I still want to rank my "session date," for each group id. 

@Kumar11109

Please check this modified PBIX file.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Its working with Dense. It was summing the rank created. I had to click on "Don't Summarize". So stupid of me. Thank You. 

 

Can you help with a conituation of this problem. I have created another topic for it. 

 

Problem 2

@Kumar11109,

Please check this PBIX file . If there is any issue, please share your PBIX file to me.

Regards,

Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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