Forum Discussion

tkrupka's avatar
tkrupka
Icon for Resolver II rankResolver II
7 years ago

Do you have the actual measures formulas you are using?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello, tkrupka , thank you for the reply! Yes, I have.

 

1. Calculate the active recruiters in the time context:

Recruiters =
CALCULATE (
    COUNT ( 'Recruiters'[Qtde recruiters] );
    FILTER (
        'Recruiters';
        'Recruiters'[De] <= MIN ( Data[Data] )
    );
    FILTER (
        'Recruiters';
        'Recruiters'[Considerar até] >= MAX ( Data[Data] )
    )
)

2. Calculate the positions closed in the time context:

Positions Closed =
CALCULATE (
    SUM ( Position[Number of Positions] );
    FILTER ( Position; Position[Status] = "Closed" );
    FILTER (
        'Closing Data';
        'Closing Data'[Closing Data] >= MIN ( Data[Data] )
            && 'Closing Data'[Closing Data] <= MAX ( Data[Data] )
    );
    FILTER (
        'Recruiters';
        'Recruiters'[De] <= MIN ( Data[Data] )
    );
    FILTER (
        'Recruiters';
        'Recruiters'[Considerar até] >= MAX ( Data[Data] )
    )
)

3. Calculate the sum of the average positions closed by number of active recruiters:

Sum of AVG  =
CALCULATE (
    [Positions Closed] / [Recruiters];
    DATESYTD ( Data[Data] )
)