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]) Return CALCULAte(    count(BeneficiáriosProjetoFATEC[CPF(ID)]),     FILTer(         ALL(BeneficiáriosProjetoFATEC),         BeneficiáriosProjetoFATEC[Início Real]<=DataMaxima&&         BeneficiáriosProjetoFATEC[DataFinal]>DataMaxima)" Infelizmente ele atende quando eu trago por Ano, mas eu precisaria trazer uma tabela com a coluna municipal. Será que alguém pode me ajudar?

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.

     

2 Replies

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

     

  • MayaraRego's avatar
    MayaraRego
    Regular Visitor
    3 years ago

    Olá Anonymous ,

     

    Super deu certo!!! Muitíssimo obrigada.