Forum Discussion
Calculating RTY
Hello!
I'm new to the community and new to PowerBI. I'm trying to calculate a rolled throughput yield column but I'm struggling to find the best way to do it. Hopefully I'm providing enough information to solve the problem.
The Accept and Reject Qty columns are measures where I use COUNT() to count the number of Accepts or Rejects in a large table then filtered by Process. The Yield column is then just Accept Qty / Total Qty. I'd like to get the RTY column which is the Product of all of the prior Yields. For example Process 3 RTY is 99% x 98% x 95%.
| Process No | Process Desc | Accept Qty | Reject Qty | Yield | RTY |
| 1 | Process 1 | 99 | 1 | 99% | 99% |
| 2 | Process 2 | 98 | 2 | 98% | 97.02% |
| 3 | Process 3 | 95 | 5 | 95% | 92.14% |
Thanks!
Andrew
Hi nguyea25 ,
Would you please try to use the following measure:
RTY = PRODUCTX ( FILTER ( ALL ( 'Table' ), 'Table'[Process No] <= MAX ( 'Table'[Process No] ) ), [Yield] )If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
4 Replies
v-deddai1-msftCommunity Support
Hi nguyea25 ,
Would you please try to use the following measure:
RTY = PRODUCTX ( FILTER ( ALL ( 'Table' ), 'Table'[Process No] <= MAX ( 'Table'[Process No] ) ), [Yield] )If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thank you so much! It worked flawlessly.
Regards,
Andrew
I have tried creating the measure suggested, but I am getting all 0.00%. I have no idea what I am doing wrong.
