Rank on item and Month Number

[joshcomputer1]

I have a dataset that has Month number, CINUM, and a Count. I want to rank the CINUM's by count by month. So if Utilive has the highest count, then it is ranked 1 for that month. Each month, the count starts over.  I would like this to be done in a calculated column if possible.  If not, a measure will work. 

[Greg_Deckler]

Column = RANKX(FILTER(ALL('Table'),[Month]=EARLIER([Month])),[Count])

[joshcomputer1]

CINUM Rank = rankx(filter(all('CI Grouped'),[Month]= earlier([Month])),[Sum Count])

I get the error : earlier refers to an earlier row context which doesn't exist. 

[v-piga-msft]

Hi @joshcomputer1,

What is [Sum Count]? Measure or calculated column?

In addition, could you please share your desired output so that we could understand your requirement better and get the solution?

Best Regards,

Cherry

[joshcomputer1]

sum count is a measure.  The desired output is another column that has the rank of the CINUM SCRUB for that month. 

[v-piga-msft]

Hi @joshcomputer1,

Is the image in your first post the original data?

Could you please share your expected output look like?

Best  Regards,

Cherry

[joshcomputer1]

The rank column is what we are trying to solve. It is the rank based on the count of that CINUM for the month. 

[parry2k]

@joshcomputer1 I just did what @Greg_Deckler provided and it worked fine. Are you adding rank as  column not measure? 

[joshcomputer1]

I got the earlier error  listed above when adding rankx in the data view as a calc'ed column. I would prefer a column.  When I tried this was rankx as a measure, I do not get an error, but all CINUM SCRUBs are a value of 1. 

[parry2k]

@joshcomputer1share your DAX expression  you are using to add rank.

[joshcomputer1]

Cinum rank =rank(filter(all('ci grouped'), [month]=earlier([month])),'ci grouped'[count])