cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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. Smiley Frustrated

 

 

4 REPLIES 4
Highlighted
Super User I
Super User I

Can you post an example of your columns / data?

 

 



Did I answer your question? Mark my post as a solution! Proud to be a Super User!


Connect with me!
Stay up to date on  
Read my blogs on  



Highlighted
Resolver I
Resolver I

Can you provide more context please?  Thank you  & welcome to the forums.

Highlighted
Microsoft
Microsoft

Hi @ssteinmann3,

 

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Microsoft
Microsoft

Hi @ssteinmann3,

 

Could you please mark the proper answers as solutions?

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors