Calculated column to count unique expressions of other column

[JD193704]

Hello,

what I am looking for seems pretty simple. I have on column with a few different expressions. As long there is the same expression inside, the calculated column should always show "1". First if there comes up a new expression, it should switch to "2". A example is shown in the table below. Should I use the INDEX function or any kind of COUNT function or something completely different? 

Thankful for any help!

Column 1	Calculated Column
ABC	1
ABC	1
ABC	1
ABC	1
EFG	2
EFG	2
HIJ	3
HIJ	3

[Ritaf1983 · Accepted solution]

Hi @JD193704 
You can create the calculated column with the following Dax :

UniqueRank = RANKX(ALL('Table'), 'Table'[Column 1],,ASC,Dense)

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly