Forum Discussion

Kumar11109's avatar
Kumar11109
Helper IV
8 years ago
Solved

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 )...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Kumar11109，

    Please check this modified PBIX file.

    Regards,
    Lydia

Kumar11109's avatar
Kumar11109
Helper IV
8 years ago

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

Its not working. :-C

 

 

Result

 

 

 

Kumar11109's avatar
Kumar11109
Helper IV
8 years ago

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. 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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's avatar
      Kumar11109
      Helper IV
      8 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Kumar11109，

        Please check this modified PBIX file.

        Regards,
        Lydia