topic Re: Rolled Throughput Yield (RTY) in DAX Commands and Tips

Rolled Throughput Yield (RTY)

Anonymous — Wed, 18 May 2022 13:11:42 GMT

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

Thanks

Re: Rolled Throughput Yield (RTY)

v-yalanwu-msft — Mon, 23 May 2022 03:20:01 GMT

Hi, Anonymous ;

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.

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.

Re: Rolled Throughput Yield (RTY)

Anonymous — Mon, 23 May 2022 09:11:15 GMT

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.

I hope that i have answered your question

Thanks

Tariq

Re: Rolled Throughput Yield (RTY)

v-yalanwu-msft — Mon, 23 May 2022 09:41:43 GMT

Hi, Anonymous ;

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:

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.

Re: Rolled Throughput Yield (RTY)

Anonymous — Mon, 23 May 2022 13:03:16 GMT

Thank you very much 🙂