Calculated Column RANKX per Group

[joshua1990]

HI experts!

I have a dimensional table that contains an indivudual value column per article:

Article	Sequence	RANKX
ABC	30	1
ABC	50	3
ABC	80	4
ABC	40	2
CDE	5	1
CDE	8	2

Now I would like to add a calculated colum that shows me the rank for this column per Article. - as you can see in the last column.

How is this possible?

[AlB · Accepted solution]

Hi @joshua1990 

Add this calculated column to the table:

NewColumn = 
RANKX(FILTER(Table1, Table1[Article] = EARLIER(Table1[Article])),  Table1[Sequence], , ASC)

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.