Forum Discussion
Rolled Throughput Yield
Hello all.
I have a problem with a table to calculate the RTY, I have good parts and bad part, yield. But I would like to know how to calculate the RTY using a measure in power bi. Manually I know that the RTY is 78.36% (98.36 x 93.14 x 97.14 x 93.06 x 94.62). But I don´t know how to get this result ( 78.36%) using a measure in power bi.
Hope you can help me.
Thanks in advance for your support.
Regards.
Hi shumadri
You can refer to the following measure.
e.g
Measure = PRODUCTX ( VALUES ( 'Table'[Station Name] ), [Yield] )You can refer to the following link to know more about the function.
PRODUCTX function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hello shumadri ,
refer to this solution https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolled-Throughput-Yield-RTY/m-p/2523430
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Hi shumadri
You can refer to the following measure.
e.g
Measure = PRODUCTX ( VALUES ( 'Table'[Station Name] ), [Yield] )You can refer to the following link to know more about the function.
PRODUCTX function (DAX) - DAX | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
