Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Thank you very much 🙂
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
57 | |
50 | |
44 | |
21 | |
19 |