cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Rolled Yield

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!

1 ACCEPTED SOLUTION
Super User

Hi @mrhish

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

2 REPLIES 2
Super User

Hi @mrhish

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

Frequent Visitor

Thanks @tamerj1 Worked like a charm!

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors