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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.