cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TariqT
Frequent Visitor

Rolled Throughput Yield (RTY)

Hi, 

I am trying to calcault the Rolled Throughput Yield (RTY) from the Frist time Yield, 

the formuler for the Rolled Throughput Yield (RTY) is

Process ID 1 = First time Yield of Process 1

Process ID 2 = First time Yield of Process 1 x First time Yield of Process Process 2  

Process ID 3 = First time Yield of Process 1 x First time Yield of Process Process 2 x First time Yield of Process Process 3

and so on 

 

The Data are in excel are 

TariqT_0-1652879397541.png

 

Thanks 

 

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @TariqT ;

You could create a measure as follow:

Measure = CALCULATE(PRODUCTX('Table',[First Time Yield]),FILTER(ALLSELECTED('Table'),[Column1]=MAX([Column1])&& [Process ID Number 。]<=MAX([Process ID Number 。])))

The final show:

vyalanwumsft_0-1653298856208.png


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yalanwu-msft
Community Support
Community Support

Hi, @TariqT ;

You could create a measure as follow:

Measure = CALCULATE(PRODUCTX('Table',[First Time Yield]),FILTER(ALLSELECTED('Table'),[Column1]=MAX([Column1])&& [Process ID Number 。]<=MAX([Process ID Number 。])))

The final show:

vyalanwumsft_0-1653298856208.png


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you very much 🙂 

TariqT
Frequent Visitor

Hi Yalan Wu,

 

Thank for your response, 

 

does your RTY need to be classified according to Work Oreder?

Yes, and if possible Projcect code 

 

Both work orders are indpented from each other, aslo, thank you for the correction, I have correct the reseult. 

TariqT_0-1653295876778.png

 

I hope that i have answered your question

Thanks 

Tariq

 

 

 

 

 

 

v-yalanwu-msft
Community Support
Community Support

Hi, @TariqT ;

Sorry, does your RTY need to be classified according to Work Oreder?
Why ID4 in Work oreder 2 in your table is 92%? Because ID5 in Work oreder 1 is 92%, but ID5 >ID4.
It would be nice if you could be a little more specific about your logic.

vyalanwumsft_0-1653275995328.png


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors