https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/linestx/m-p/3234307#M118813 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="556565" data-lia-user-login="jshumaker" class="lia-mention lia-mention-user">jshumaker</a>&nbsp;</P> <P>please try</P> <P>r2_fk01 =<BR />VAR l =<BR />LINESTX ( 'fk01 mx', [max pct], [k1] )<BR />RETURN<BR />AVERAGEX ( l, [CoefficientOfDetermination] )</P> Sun, 14 May 2023 15:21:36 GMT tamerj1 2023-05-14T15:21:36Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/linestx/m-p/3234296#M118812 <P>I am confused how the LINESTX function works within a group.&nbsp; The first screen shot is of a matrix showing that there is only 1 k1 record for any given l0 group.&nbsp; The second screen shot is of a matrix where I am trying to display the LINESTX column of R2 (DAX formula below).&nbsp; The second matrix only has l0 as part of the row group and therefore should be providing the LINESTX function a unique value for the LINESTX x-value parameter of [k1].&nbsp;&nbsp;<BR /><BR />r2_fk01 =<BR />var l = LINESTX('fk01 mx',[max pct],[k1])<BR />return SELECTCOLUMNS(l,[CoefficientOfDetermination])</P><P>&nbsp;</P><P><img /><img /></P><P>&nbsp;</P> Sun, 14 May 2023 14:28:38 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/linestx/m-p/3234296#M118812 jshumaker 2023-05-14T14:28:38Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/linestx/m-p/3234307#M118813 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="556565" data-lia-user-login="jshumaker" class="lia-mention lia-mention-user">jshumaker</a>&nbsp;</P> <P>please try</P> <P>r2_fk01 =<BR />VAR l =<BR />LINESTX ( 'fk01 mx', [max pct], [k1] )<BR />RETURN<BR />AVERAGEX ( l, [CoefficientOfDetermination] )</P> Sun, 14 May 2023 15:21:36 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/linestx/m-p/3234307#M118813 tamerj1 2023-05-14T15:21:36Z