cancel
Showing results for
Did you mean:

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

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:

Can someone help me with the  formula.

The way I want is also given here.

Thank You,

Kumar Ashwarya

1 ACCEPTED SOLUTION
Employee

@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.
8 REPLIES 8
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)

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.
Helper IV

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

Its not working. :-C

Result

Helper IV

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.

Employee

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

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

Employee

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

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

Employee

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