Headcount

Hi MayaraRego ,

Due to I don't know your data model, here I will give you some suggestions. I think there should be a [municipal] column in BeneficiáriosProjetoFATEC table. Try ALLEXCEPT() function.

FATEC BeneficiariesQty =
VAR DateMaximum =
    MAX ( 'Calendar'[Date] )
RETURN
    CALCULATE (
        COUNT ( BeneficiariesProjectFATEC[CPF(ID)] ),
        FILTER (
            ALLEXCEPT ( BeneficiariesProjectFATEC, 'BeneficiariesProjectFATEC'[municipal] ),
            FATECProjectBeneficiaries[ActualStart] <= MaxDate
                && FATECProjectBeneficiaries[EndDate] > MaxDate
        )
    )

Best Regards,
Rico Zhou

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