lookupvalue

jemalosa ,

I suppose your tables are connected via Nombre column:

I've created 'Tabla2' via Tabla2 = DISTINCT(Tabla1[Nombre]).

In case of calculated columns:

CAPSO = 
VAR currNombre = Tabla2[Nombre]
VAR _tC =
    CALCULATETABLE (
        Tabla1,
        Tabla1[Nombre] = currNombre
            && CONTAINSSTRING ( Tabla1[Producto], "CAPSO" )
    )
VAR maxCID = MAXX ( _tC, Tabla1[ID CAPSO] )
RETURN 
CALCULATE ( MAX ( Tabla1[Producto] ), FILTER ( _tC, [ID CAPSO] = maxCID ) )

PRICCOA = 
VAR currNombre = Tabla2[Nombre]
VAR _tP =
    CALCULATETABLE (
        Tabla1,
        Tabla1[Nombre] = currNombre
            && CONTAINSSTRING ( Tabla1[Producto], "PRICCOA" )
    )
VAR maxPID = MAXX ( _tP, Tabla1[ID PRICCOA] )
RETURN
CALCULATE ( MAX ( Tabla1[Producto] ), FILTER ( _tP, [ID PRICCOA] = maxPID ) )

In case of measures:

#CAPSO = 
VAR currNombre = MAX(Tabla2[Nombre])
VAR _tC =
    CALCULATETABLE (
        Tabla1,
        Tabla1[Nombre] = currNombre
            && CONTAINSSTRING ( Tabla1[Producto], "CAPSO" )
    )
VAR maxCID = MAXX ( _tC, Tabla1[ID CAPSO] )
RETURN 
    IF (
        HASONEVALUE ( Tabla2[Nombre] ),
        COALESCE (
            CALCULATE ( MAX ( Tabla1[Producto] ), FILTER ( _tC, [ID CAPSO] = maxCID ) ),
            ""
        )
    )

#PRICCOA = 
VAR currNombre = MAX(Tabla2[Nombre])
VAR _tP =
    CALCULATETABLE (
        Tabla1,
        Tabla1[Nombre] = currNombre
            && CONTAINSSTRING ( Tabla1[Producto], "PRICCOA" )
    )
VAR maxPID = MAXX ( _tP, Tabla1[ID PRICCOA] )
RETURN
    IF (
        HASONEVALUE ( Tabla2[Nombre] ),
        COALESCE (
            CALCULATE ( MAX ( Tabla1[Producto] ), FILTER ( _tP, [ID PRICCOA] = maxPID ) ),
            ""
        )
    )

If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.