Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculate Comulative Average Headcount

Hi Everyone! Sorry if my english is not good.   I want to calculate cumulative average headcount. I have two tables The Data_Table have the records of employees(termination date(fecha de baja [f...
rautaniket0077's avatar
rautaniket0077
Icon for Resolver I rankResolver I
3 years ago

Try replacing "Date" inside allselected with "Date[year]" because for me with similar kind of data these below 2 measures are working fine.
1)

Cummulative count =
CALCULATE(
    [Order Count],
    FILTER(
        ALLSELECTED('Date'),
        'Date'[Year] <= MAX('Date'[Year])
    )
)

2)
cumulative average =
Var a =     FILTER(
            ALLSELECTED('Date'[Year]), ---- in your case calendario with calendario[Ano]
            'Date'[Year] <= MAX('Date'[Year])
)

return DIVIDE([Cummulative count], COUNTROWS(a))


 




  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I tried the measure.The measure does work when I take the date from the same table where the data is.

    But when I take the date from the calendar table, the measure doesnt work.

    It should work, because is the same step,only I add the instruction  userelationship to connect the tables, but it doesn´t work

     

    Could I share the exercise with you by email?

    We could review the exercise together.

     

    Thanks!