Forum Discussion

MayaraRego's avatar
MayaraRego
Regular Visitor
3 years ago
Solved

Headcount

Oi pessoal, estou precisando de uma ajuda. Preciso calcular o Headcount da empresa.. consegui utilizando a seguinte fórmula: "FATEC Qtde de Beneficiarios = var DataMaxima = max('dCalendário'[Data]) R...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

     

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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.