topic Re: average per hour in Developer

average per hour

Andrea78m — Thu, 01 Mar 2018 21:29:14 GMT

hallo,

I'd get for each operator the average throught the hours

so I put:

DDD =
AVERAGEX (
    SUMMARIZE (
        DMGLR04L;
        DMGLR04L[CODICE_OPERATORE];
        DMGLR04L[ORA_];
        "ZZZZ"; SUM ( DMGLR04L[NUMERO_COLLI_INTERI_NON_PALLET] )
    );
    [ZZZZ]
)

but the sum is not corret

The result is 230,33, instead 205,57

where is the error?

thanks for help

Re: average per hour

v-ljerr-msft — Fri, 02 Mar 2018 07:41:46 GMT

Hi @Andrea78m,

Could you try the formula below to see if it works?

DDD =
AVERAGEX (
    SUMMARIZE (
        DMGLR04L;
        DMGLR04L[CODICE_OPERATORE];
        DMGLR04L[ORA_];
        "ZZZZ"; CALCULATE ( SUM ( DMGLR04L[NUMERO_COLLI_INTERI_NON_PALLET] ) )
    );
    [ZZZZ]
)

Regards

Re: average per hour

Andrea78m — Fri, 02 Mar 2018 08:18:19 GMT

unfortunately the result is the same.

I tried also to count ORA_:

DDD =
AVERAGEX (
    SUMMARIZE (
        DMGLR04L;
        DMGLR04L[CODICE_OPERATORE];
        DMGLR04L[ORA_];
        "ZZZZ"; count ( DMGLR04L[ORA_] )
    );
    [ZZZZ]
)

but it gives me an incorrect value.

It gives me 21.33 instead 3??