Rolled Yield

[mrhish]

Hi Community!

I am trying to calculate rolled yield over a time period, but cant get the correct result.

Date	Process	OK+R	Total	Yield
19/3-2024	Process A	2010	2016	0.99702381
18/3-2024	Process A	1234	1244	0.991961415
19/3-2024	Process B	1161	1183	0.981403212
18/3-2024	Process B	1822	1865	0.9769437

And this is the result over the time period. First sum OK+R and Total per process, then dividing them to get yield per process.

Process	OK+R	Total	Yield
Process A	3244	3260	0.995092025
Process B	2983	3048	0.978674541

Rolled yield = 0.995092025*0.978674541 = 0.973871

I need a measure to do this calculation. Tried with variants of ProductX but cant get the correct rolled yield number. Any help appriciated!

[tamerj1 · Accepted solution]

Hi @mrhish 

please try

Yied =
PRODUCTX (
VALUES ( 'Table'[Process] ),
DIVIDE ( [OK+R Measure], [Total Measure] )
)

[mrhish]

Thanks @tamerj1 Worked like a charm!