Filter after rankx virtual table

[fedeg]

Hi,

Im struggling with the following measure. Due to my requirements I know that I have to create a rank after creating a filter. When the rank is created I want to count only the ones. The variables will be dinamyc with a calendar table, but i put it here with a specific date. Can you please help me?

MEASURE 'Tabla de medidas'[prueba] = 
VAR FechaHasta = DATE(YEAR(TODAY()), 4, 30)
VAR FechaDesde = DATE(YEAR(TODAY()), 4, 1)

VAR TablaFiltrada =
    CALCULATETABLE(
        'Asignacion',
        (
            (
                'Asignacion'[fecha_ingreso] <= FechaDesde &&
                'Asignacion'[fecha_devuelto] >= FechaDesde
            ) ||
            (
                'Asignacion'[fecha_ingreso] >= FechaDesde &&
                'Asignacion'[fecha_ingreso] < FechaHasta + 1
            )
        ),
        ALLEXCEPT(Asignacion, Asignacion[fecha_ingreso], Asignacion[fecha_devuelto])
    )

VAR TablaConRank =
    ADDCOLUMNS(
        TablaFiltrada,
        "Rank",
        RANKX (
            FILTER (
                TablaFiltrada,
                [deuda_id] = EARLIER ( [deuda_id] )
            ),
            [dias_atraso] & [documento_id],
            ,
            DESC,
            Dense
        )
    )

RETURN
    COUNTROWS((FILTER(TablaConRank, [Rank] = 1)))

[MFelix]

Hi @fedeg 

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.