Making a counter by type of row that restart

[omarevp]

Hello everyone.

What i'm trying to do is to count every row in my table by type. I don't know if i'm explaining myself so, this is what i've got:

this is the current table:

I just want to add a new column that count "Trabajo vinculado" by type and that restart every time the field "Trabajo vinculado" is different. Something like this:

Trabajo vinculado                                 Count

Analista de Soporte Técnico..                    1

Analista de Soporte Técnico..                    2

Analista de Soporte Técnico..                    3

Analista de Soporte Técnico..                    4

Analista de Compras Ssr                          1

Java Developer                                        1

Java Developer                                        2

Java Developer                                        3

Administrador PHP                                 1

Administrador PHP                                 2

Administrador PHP                                 3

I know is got to be pretty easy to do but i don't know how.

Thanks for your attention.

[Zubair_Muhammad · Accepted solution]

Hi @omarevp

Try this calculated column

Column =
RANKX (
    FILTER (
        TableName,
        TableName[Trabajo vinculado] = EARLIER ( TableName[Trabajo vinculado] )
    ),
    TableName[Fecha Presendato],
    ,
    asc,
    DENSE
)