topic I need to create a measure that calculates the average OEE for the last 24 hours in DAX Commands and Tips

I need to create a measure that calculates the average OEE for the last 24 hours

Anonymous — Fri, 09 Dec 2022 19:54:43 GMT

I need to calculate the average OEE for the last three shifts, but I only have shift as a time reference. However, I do not want to count OEE if no real parts were made. Also, some workplaces have multiple rows per shift.

I do not know how to make the filter count shift as a time.

OEE = CALCULATE(AVERAGE(ReportData[OEE]), ReportData[Imputation date] = TODAY(), ReportData[OEE] > 0)))

Workplace	Imputation date	Shift	Manufacturing reference	Real parts/h	OEE
C316	12/4/2022	A	A3301	0.00	0.00
C316	12/4/2022	B	A3301	0.00	0.00
C316	12/4/2022	C	A3301	20.50	14.48
C316	12/5/2022	A	A3301	0.00	0.00
C316	12/5/2022	B	A3301	0.00	0.00
C316	12/5/2022	C	A3301	0.00	0.00
C316	12/6/2022	A	A3301	0.00	0.00
C316	12/6/2022	B	A3301	0.00	0.00
C316	12/6/2022	C	A3301	0.00	0.00
C316	12/7/2022	A	A3301	0.00	0.00
C316	12/7/2022	B	A3301	0.00	0.00
C316	12/7/2022	C	A3301	0.00	0.00
C316	12/8/2022	A	A3301	0.00	0.00
C316	12/8/2022	B	A3301	0.00	0.00
HL2	12/6/2022	C	S3119	191.40	48.14
HL2	12/6/2022	C	S3299	191.40	41.45
HL2	12/7/2022	A	S3119	182.89	50.21
HL2	12/7/2022	A	S3299	182.89	50.21
HL2	12/7/2022	B	S3119	204.03	61.12
HL2	12/7/2022	B	S3147	195.32	48.97
HL2	12/7/2022	B	WR	92.31	0.00
HL2	12/7/2022	C	S3147	223.44	76.30
HL2	12/7/2022	C	S3209	223.44	76.30
HL2	12/8/2022	A	S3149	195.53	47.59
HL2	12/8/2022	A	S4119	195.53	53.76
HL2	12/8/2022	B	S3149	216.29	69.86
HL2	12/8/2022	B	S3505	151.68	23.86
HL2	12/8/2022	B	S3506	151.68	23.65
HL2	12/8/2022	B	S4119	216.29	69.86
HL2	12/8/2022	C	S3505	161.12	69.36
HL2	12/8/2022	C	S3506	161.12	69.36
HL2	12/9/2022	A	S3143	158.82	7.23
HL2	12/9/2022	A	S3144	158.82	7.23
HL2	12/9/2022	A	S3505	159.72	56.59
HL2	12/9/2022	A	S3506	159.72	56.59
HL4	12/4/2022	A	S4600	404.90	87.66

Re: I need to create a measure that calculates the average OEE for the last 24 hours

lbendlin — Sat, 10 Dec 2022 18:10:54 GMT

Please define what you mean by "the last three shifts". Will the user see a report that shows all days, or only the latest day with data? What is the expected outcome based on the sample data you provided?

some workplaces have multiple rows per shift

How should the average be calculated in that case? Average of sums or Average of values?

See attached for a proposal.

Re: I need to create a measure that calculates the average OEE for the last 24 hours

Anonymous — Sun, 11 Dec 2022 02:08:23 GMT

lbendlin ,

I need it only to show the last 24 hours, but I do not have hours, so I have to use shifts. I want to filter the shift and the work center. I will have a scorecard with the average OEE, which I need to update with every shift change to show the last 24 hours (the last three shifts). I need the ability to use a shift filter to look at a specific shift and a work center filter to look at a particular department. The manufacturing reference is the parts made in the work center that day. I have a calendar, work centers, shifts, and manufacturing reference lookup table. In the case of multiple rows, I need the average of the values. I need it to be the average at the bottom level, manufacturing reference. Dates -> shift -> work center -> manufacturing reference.

Re: I need to create a measure that calculates the average OEE for the last 24 hours

PATY_CAMPER — Tue, 25 Nov 2025 19:00:28 GMT

Se você tiver a escala de trabalho do turnos, acredito que ficará mais fácil para você, pois no meu projeto tenho que fazer analise de 4 turnos , e eu uso a escala de trabalho deles. se vc trabalha com um banco de dados, onde consta o gereciamento de produção, lá consta a entrada e saída de cada turno com datas e horários, sendo assim, vc pega essa base e no power bi , faz uma tabela só com os turnos .

Re: I need to create a measure that calculates the average OEE for the last 24 hours

Ray_Minds — Fri, 23 Jan 2026 10:05:28 GMT

Answer :

The calculation needs to be at the lowest level manufacturing reference, then rolled up to shift → work center → date.

Query :

Result :