topic Re: Rolled Yield in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolled-Yield/m-p/3833814#M149902 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp;Worked like a charm!</P> Fri, 12 Apr 2024 11:59:29 GMT mrhish 2024-04-12T11:59:29Z Rolled Yield https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolled-Yield/m-p/3833143#M149890 <P>Hi Community!<BR /><BR />I am trying to calculate rolled yield over a time period, but cant get the correct result.</P><P>&nbsp;</P><TABLE border="1"><TBODY><TR><TD><STRONG>Date</STRONG></TD><TD><STRONG>Process</STRONG></TD><TD><STRONG>OK+R</STRONG></TD><TD><STRONG>Total</STRONG></TD><TD><STRONG>Yield</STRONG></TD></TR><TR><TD>19/3-2024</TD><TD>Process A</TD><TD>2010</TD><TD>2016</TD><TD>0.99702381</TD></TR><TR><TD>18/3-2024</TD><TD>Process A</TD><TD>1234</TD><TD>1244</TD><TD>0.991961415</TD></TR><TR><TD>19/3-2024</TD><TD>Process B</TD><TD>1161</TD><TD>1183</TD><TD>0.981403212</TD></TR><TR><TD>18/3-2024</TD><TD>Process B</TD><TD>1822</TD><TD>1865</TD><TD>0.9769437</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>And this is the result over the time period. First sum OK+R and Total per process, then dividing them to get yield per process.<BR /><BR /></P><TABLE border="1"><TBODY><TR><TD><STRONG>Process</STRONG></TD><TD><STRONG>OK+R</STRONG></TD><TD><STRONG>Total</STRONG></TD><TD><STRONG>Yield</STRONG></TD></TR><TR><TD>Process A</TD><TD>3244</TD><TD>3260</TD><TD>0.995092025</TD></TR><TR><TD>Process B</TD><TD>2983</TD><TD>3048</TD><TD>0.978674541</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Rolled yield =&nbsp;0.995092025*0.978674541 = <U><STRONG>0.973871<BR /><BR /></STRONG></U>I need a measure to do this calculation. Tried with variants of ProductX but cant get the correct rolled yield number. <STRONG>Any help appriciated!</STRONG><U><STRONG><BR /></STRONG></U></P> Fri, 12 Apr 2024 08:24:40 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolled-Yield/m-p/3833143#M149890 mrhish 2024-04-12T08:24:40Z Re: Rolled Yield https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolled-Yield/m-p/3833186#M149892 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="348219" data-lia-user-login="mrhish" class="lia-mention lia-mention-user">mrhish</a>&nbsp;</P> <P>please try</P> <P>Yied =<BR />PRODUCTX (<BR />VALUES ( 'Table'[Process] ),<BR />DIVIDE ( [OK+R Measure], [Total Measure] )<BR />)</P> Fri, 12 Apr 2024 08:48:18 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolled-Yield/m-p/3833186#M149892 tamerj1 2024-04-12T08:48:18Z Re: Rolled Yield https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolled-Yield/m-p/3833814#M149902 <P>Thanks&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="317289" data-lia-user-login="tamerj1" class="lia-mention lia-mention-user">tamerj1</a>&nbsp;Worked like a charm!</P> Fri, 12 Apr 2024 11:59:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Rolled-Yield/m-p/3833814#M149902 mrhish 2024-04-12T11:59:29Z