Day Ranking For Group Access

[Kumar11109]

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: 

Can someone help me with the  formula. 

 Sample Data

The way I want is also given here. 

Thank You, 

Kumar Ashwarya 

[v-yuezhe-msft]

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

Regards,
Lydia

[Kumar11109]

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

Its not working. :-C

Result

[Kumar11109]

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. 

[v-yuezhe-msft]

@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

[Kumar11109]

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

[v-yuezhe-msft · Accepted solution]

@Kumar11109，

Please check this modified PBIX file.

Regards,
Lydia

[Kumar11109]

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

[v-yuezhe-msft]

@Kumar11109,

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

Regards,

Lydia