Average of production by date and shift

[mariba]

Hi there,

Im trying to calculate the average of production by date and shift.

Each day has 1, 2 or three shifts. Its not fixed.

For the average of production by date I used this:

Quantity (m2) ΜΟ =

AVERAGEX(

    KEEPFILTERS(VALUES('Calendar'[Date])),

    CALCULATE([Quantity (m2) Output])

)

But now I need the average by shift.

Any ideas?

Thank you in advance!

[rubayatyasmin]

Hi, @mariba 

Average Production by Shift =
AVERAGEX(
KEEPFILTERS(VALUES('Production'[Shift])),
CALCULATE(
[Quantity (m2) Output],
REMOVEFILTERS('Calendar'[Date]) // Optionally remove date filter if you want the average across all dates
)
)