the last result

[Bebecirux]

Hi @olgad good afternoon

I have a problem with the last fob size, it should give me the last one, but in some cases the month is repeated and then it adds them, how can I do so that it gives me only 1 value

dax: measures

Ultimo FOB =

VAR UltimaFechaFOB =

    CALCULATE(

        MAX(CostosXProveedor[Fecha]),

        ALL(CostosXProveedor[FOB])

    )

RETURN

    CALCULATE(

        SUM(CostosXProveedor[FOB]),

        FILTER(CostosXProveedor, CostosXProveedor[Fecha] = UltimaFechaFOB

    ))

How should I complete my measurement only so that it brings me the last value and does not add me

thank you so much

[Bebecirux]

@Ahmee thank you so much

[Ahmedx · Accepted solution]

Ultimo FOB =
VAR UltimaFechaFOB =
    CALCULATE(
        MAX(CostosXProveedor[Fecha]),
        ALL(CostosXProveedor[FOB])
    )

RETURN
    CALCULATE(
        MAX(CostosXProveedor[FOB]),
        FILTER(CostosXProveedor, CostosXProveedor[Fecha] = UltimaFechaFOB
       
    ))