Help to count within the period of dates

[fsouza_ata]

These are the images for ease of understanding, I need to tell the column "id_apontamento" within the period.

Image 1 is the problem. this is my DAX now:

Coluna = CALCULATE(COUNT(fDados_Servico[ID_APONTAMENTO]);

DATESBETWEEN(fDados_Servico[DATA];FIRSTDATE(dCalendario[DATA]);LASTDATE(dCalendario[DATA]));

ALLEXCEPT(fDados_Servico;fDados_Servico[ID_APONTAMENTO]))

but in image, this "dax" works, I do not understand why.

[v-yuta-msft · Accepted solution]

@fsouza_ata ,

You may modify your measure like pattern below and check if it can meet your requirement:

Coluna =
VAR First_Date =
    MIN ( dCalendario[DATA] )
VAR Last_Date =
    MAX ( dCalendario[DATA] )
RETURN
    CALCULATE (
        COUNT ( fDados_Servico[ID_APONTAMENTO] );
        FILTER (
            ALLEXCEPT ( fDados_Servico; fDados_Servico[ID_APONTAMENTO] );
            dCalendario[DATA] >= First_Date
                && dCalendario[DATA] <= Last_Date
        )
    )

Community Support Team _ Jimmy Tao

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