Forum Discussion
Counting and Ranking unique IDs
I am looking to Count and Rank unique IDs associated with one unique value. This table from another post is very close to what i'm looking to do. However, I keep getting the error "Earlier/Earliest refers to an earlier row context which doesn't exist". I'm completely puzzled. :smileyfrustrated:
4 Replies
Can you post an example of your columns / data?
Can you provide more context please? Thank you & welcome to the forums.
Hi Anonymous,
It's a calculated column in the post of your link. Maybe you want a measure that can't use the formula directly. It could be something like below. Please share a sample of yours.
Column = RANKX ( ALL ( Table1[Address ID] ), CALCULATE ( COUNT ( Table1[PersonID] ) ) )
Best Regards,
Dale
Hi Anonymous,
Could you please mark the proper answers as solutions?
Best Regards,
Dale
