Forum Discussion

Jessica07's avatar
Jessica07
Frequent Visitor
3 years ago
Solved

Rank changing based on date for each sub-group

I have a table containing data of ProjectID and each ProjectID has multiple periods. Each ProjectID is like a sub-group in my data in 'ProjectID' column. Each ProjectID has multiple period numbers th...
Need Help
  • andhiii079845's avatar
    andhiii079845
    3 years ago

    If the Periodnumber is no measure, i only know that you have to create one first:

    Measure = sum('Table'[PeriodNumber])
     
    And than use rankx
    Measure 2 = RANKX(ALLEXCEPT('Table','Table'[ProjectID]),CALCULATE([Measure]),,DESC)
     
    Perhaps someone know how to avoid to create the first measure? 
andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

If the Periodnumber is no measure, i only know that you have to create one first:

Measure = sum('Table'[PeriodNumber])
 
And than use rankx
Measure 2 = RANKX(ALLEXCEPT('Table','Table'[ProjectID]),CALCULATE([Measure]),,DESC)
 
Perhaps someone know how to avoid to create the first measure?