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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Employee
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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.