Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
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??
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |