Forum Discussion

fedeg's avatar
fedeg
Frequent Visitor
3 years ago

Filter after rankx virtual table

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)))


1 Reply

  • 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.