Rolled Throughput Yield

[shumadri]

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.

[Anonymous · Accepted solution]

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.

[Idrissshatila]

Hello @shumadri ,

refer to this solution https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolled-Throughput-Yield-RTY/m-p/2523...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡